ASK
Ask anything or provide a subject to get information from ChatGPT
It can be used to get some facts, generate creative texts, or get professional-level advice from AI.  This powerful function covers most cases, from email writing to solving logical problems.
Examples
=ASK_X("What is the capital of France?")

Output: Paris
=ASK_X(A1:B4)

Output Example:
Answer for A1, Answer for B1
Answer for A2, Answer for B2
=ASK_X("What are the key principles of a balanced diet?", {"act_like", "Nutritionist"; "temperature", IFS($C$6="Very Creative",0.8,$C$6="Medium",0.5,$C$6="Very Rational",0)})

Output Example: A well-rounded diet incorporates diverse foods from various categories, such as fruits, veggies, whole grains, lean proteins, and good fats. It's crucial to ingest these foodstuffs in appropriate quantities, ensuring you obtain vital nutrients, manage your weight, and stave off health issues.

=ASK_X("What is the capital of " & B2, {"output_language","Polish";"context","Answer in form: City, Main Airport 3 letter code"})

Output Example: Warszawa, WAW
Arguments List
=ASK_X(question, [options])
=ASK_Y(question, [options])
question
Request to OpenAI can be a question or subject. It can be a list or table of questions; in this case, you will get answers for each question.
For example: "Capital of France", A2, A1:A4, A2:B4 or "Capital of " & B2
Options List
Particular object at the end of a formula which contains optional parameters values in the form {"parameter_name",value; "next_parameter_name",value}
For Example: {"output_language","French"; "extra_instructions","Remember this info: " & A1; "act_like","Artist from the 18th century"}
with_kb
It allows the function to access and utilize the spreadsheet's Knowledge Base, enriching the answer with pre-configured data and insights. This enhances the function's ability to create more context-aware and informative answers. Recommend to deactivate if a result requires general knowledge and the Knowledge Base information is not enough to get the answer.
Options: FALSE or TRUE
with_web
It enables the function to fetch data from the internet, adding a layer of real-time information to your table. While this feature can provide valuable insights, be aware that it may increase both the cost and the time required for execution, and the quality of results may vary based on the search.
Options: FALSE or TRUE
output_language
Set output language for the function result; it can differ from argument language. If not set, answer language can vary depending on options and parameter values.
For Example: "EN", "French", or  "Most popular Language in the US"
temperature
Adjust the deviation from deterministic answers from 0 (default, high-confidence) to 1 (greater diversity). In other words, it's the AI's creativity for the answer.
For Example: 0, 0.4, or 1
act_like
Specify a role, profession, or perspective for the AI to adopt when generating a response; this parameter guides the AI in providing more context-specific or specialized answers.
For example: "UX Designer", "Nutriologist", or "Chess piece"
extra_instructions
Provide additional information or instructions to get a better answer.
For example: "Use metric system", "From the business perspective", or "Remember this: " & B2
model
Model affects quality, speed, and tokens count of tokens to use. We choose the optimal model ("default") by default, and here it's gpt-3.5-turbo. Information about models.
Options: "default", "gpt-4, "gpt-3.5-turbo", or "gpt-3.5-turbo-16k"
max_tokens
Limit the number of tokens that can be used for one function run. By default, it's limited only by the model.
1 token ≈ 4 chars in English
1 token ≈ 3/4 words
100 tokens ≈ 75 words
1-2 sentences ≈ 30 tokens
1 paragraph ≈ 100 tokens
1,500 words ≈ 2048 tokens
For Example: 100, 350, or 2048
Websheet AI is designed to empower you in crafting the perfect website effortlessly. Discover the myriad of options and bring your vision to life.