.png){kind=logo}
Troubleshooting Checkbox Issues in Formula Columns
Having a problem getting checkboxes ticked correctly in a formula column.
Having a problem getting checkboxes ticked correctly in a formula column.
To create a formula column with checkboxes: 1. Add a new column and select "Formula" 2. Use the AI Formula Generator box to describe what you want to accomplish 3. Click "Generate Formula" to create the formula 4. Review the sample output 5. Click "Save Formula" to apply the changesIf you need additional assistance or have specific questions about your formula, please let me know. If you require further help, you can request human assistance by clicking on "Talk to a person". Source: Formulas
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Hey Andreas, thanks for reaching out! Great to hear from you! :) This appears to be due to the wording of the 'Use AI' prompt. * This error seems to have come from stating "get {{column}} return true if.....else false...." I removed "get" and stated the formula like: * "if {{column}} contains ....... return true, else false.......". Changing this wording seems to have alleviated the error and is slowly but surely updating on all 30k rows. Hope this helps! Let me know if you have any other questions! In the meantime, I’ll go ahead and close this ticket. :)
heyyy Owen - very very cool thanks for your help. Odd though, it did work before like this. I’ll use your suggested syntax going fwd
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.
