Troubleshooting Checkbox Issues in Formula Columns

Andreas W. · 2024-12-04 14:35:03.827177+00

Having a problem getting checkboxes ticked correctly in a formula column.

Troubleshooting Checkbox Issues in Formula Columns | Clay

7 comments

· Sorted by Oldest

Channeled
APP
·
·
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
Andreas W.
·
·
https://www.loom.com/share/77bd7baecde44b478251c6b1e1f5bdbf?sid=a2285c32-4222-48ff-978d-20cb7f359351 https://app.clay.com/workspaces/261603/workbooks/wb_8WHAumH9NEWX/tables/t_cwpx9QC8Ungq/views/gv_GFUfXfEU95Fm
Loading attachments
Channeled
APP
·
·
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!
Owen C.
·
·
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. :)
1
Andreas W.
·
·
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
Owen C.
·
·
Of course! Very Interesting, I'll keep an eye out for other info regarding why this may be. Let me know if you run into any other issues with this. :)
🙌1
Channeled
APP
·
·
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 Clay Support.

Channeled
APP
·
·
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
Andreas W.
·
·
https://www.loom.com/share/77bd7baecde44b478251c6b1e1f5bdbf?sid=a2285c32-4222-48ff-978d-20cb7f359351 https://app.clay.com/workspaces/261603/workbooks/wb_8WHAumH9NEWX/tables/t_cwpx9QC8Ungq/views/gv_GFUfXfEU95Fm
Loading attachments
Channeled
APP
·
·
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!
Owen C.
·
·
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. :)
1
Andreas W.
·
·
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
Owen C.
·
·
Of course! Very Interesting, I'll keep an eye out for other info regarding why this may be. Let me know if you run into any other issues with this. :)
🙌1
Channeled
APP
·
·
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 Clay Support.