Sum of column A when column B is customer and column C starts with VIP
Split column C by space and get the second word if the first word is Mr
Lookup column F from sheet2!A:C and get the third column
Yes, it is FREE. However there will be a usage limit as every generation will cost us money.
There are more functions for users who sign in. For example, you can use AI to analyze a formula. We are also thinking to add more features and increase quota.
The usage limit will diff based on user type. For anonymous users it will be applied on IP address. For signed up users, it will be applied on email address.
The AI can not guarantee to generate correct formula. You are supposed to copy the formula to your sheet and verify its correctness by yourself.
Google Ads
Start by describing the problem you want to solve with the formula. Provide as much detail as possible about the data you are working with, the calculations you need to perform, and any specific requirements or constraints.
Give the AI model relevant context about the data you are working with. This includes information about the structure of your data, any formulas you have already used, and any other relevant information that will help the model generate a more accurate formula.
Clearly define the inputs and outputs of the formula. This will help the AI model understand what data it needs to work with and what results it should be aiming for.
Use precise language that describes the type of calculation or manipulation you want the formula to perform. Avoid using vague or ambiguous terms that could lead to confusion.
Provide examples of the type of input data you will be working with and the expected output from the formula. This will help the AI model understand the problem and generate more accurate formulas.
Avoid using overly complex language or technical jargon. Keep the prompt simple and easy to understand, so the AI model can focus on generating accurate formulas.