Description
Allows a user to request R2 Copilot from any Excel table cell.
Syntax
COPILOTR2(prompt, [content], [completion_length], [completion_tone],[knowledge]).The COPILOTR2 function syntax has the following arguments:
- Prompt
- - Required parameter. A text string, or cell address that contains user question or command, eg. Who is Sebastien Loeb?
- Content
- - Optional parameter. A text string or cell range that contain additional text data that should be considered to answer user’s prompt.
- Completion_length
- - Optional parameter. Specifies the number of characters for the AI completion. Default value 1000, min 10, max 8000.
- Completion_tone
- - Optional parameter. A text string or cell address that contains text data that describes desired R2 Copilot a tone of the answer and general behavior, eg. “You always answer formally”. Max length of the parameter is 512 characters and always should be in quotation marks.
- Knowledge
- - Optional parameter. A text string that tells R2 Copilot a source of the knowledge. Currently, only the value 'global' is allowed.
Examples
=COPILOTR2('proofread',A1)=COPILOTR2(“Translate to Japanese”, ”Thank you for your email”, 1000, “formal”, “global”)