hi, can I use the RANDBETWEEN(1, 2) formula with more than 2 numbers? If I write RANDBETWEEN(1, 2, 3) it still divides all rows into 1 and 2
The RANDBETWEEN formula in Clay is typically used to generate random numbers between two specified values. To generate random numbers among more than two values, you'll need to use a different approach using the AI Formula Generator. Here's how you can do it: 1. Add a new column and select "Formula" 2. In the AI Formula Generator box, type your requirement, such as "Generate a random number between 1, 2, and 3" 3. Click "Generate Formula" 4. Review the sample output 5. If it meets your needs, click "Save Formula" This method allows you to create more complex random number generation formulas tailored to your specific needs. Would you like me to provide an example of how to phrase your requirement in the AI Formula Generator?
Source: Formulas
i get this error: "You must use at least one column in your formula. Enter "/" to insert a column in the input box above." what column should I insert?
To generate a random number among 1, 2, and 3 using the AI Formula Generator without getting the "You must use at least one column in your formula" error, you don't actually need to insert any specific column. Instead, you can phrase your requirement differently. Here's what you can do: 1. Add a new column and select "Formula" 2. In the AI Formula Generator box, type: "Generate a random number among 1, 2, and 3" 3. Click "Generate Formula" 4. Review the sample output 5. If it meets your needs, click "Save Formula" This approach should work without requiring you to reference any existing columns. If you still encounter issues, you may need to request human assistance for further troubleshooting.
followed step by step, doesnt work. I always get prompted to use at least one column
To generate a random value among 1, 2, and 3 without the error, follow these steps: 1. Add a new column and select "Formula" 2. In the AI Formula Generator box, type: "Generate a random number between 1 and 3" 3. Click "Generate Formula" 4. Review the sample output 5. If it meets your needs, click "Save Formula" This approach should work without requiring you to reference any existing columns. The AI will generate the appropriate code to give you the desired output. If you still encounter issues, you may need to request human assistance for further troubleshooting. You can do this by clicking on "Talk to a person" in the chat.
Hey - just to clarify, If you want to assign a random value from a specific list (like 1, 2, or 3), you can use a formula like this instead: If /created at has value, return a random number from 1, 2, or 3." Referencing the created at will allow it to work as formulas are conditionals. Let me know what you're trying to achieve and I can help you set it up!
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.