Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Checkbox Column Formula Error in Clay: Boolean Conversion Issue

·

·

Hi Clay Team- Bruno R. i created a check box column and ran a formula to return True (check the box) and am getting the right output with the following message "Whoops! This value could not be converted to this column's data type (boolean). Here's the table: https://app.clay.com/workspaces/507736/workbooks/wb_NFfNxS5AZDkx/tables/t_wkTTHdRoonAS/views/gv_J2hemjmiC5Z3 The output is correct but why is this error message present?

Checkbox Column Formula Error in Clay: Boolean Conversion Issue | Clay

Loading attachments

3 comments

· Sorted by Oldest

Channeled
APP
·
·
This error typically occurs when there's a mismatch between the column's data type and the formula output. For checkbox columns, the expected data type is boolean (true/false). To resolve this: 1. Check your column's data type: - Right-click the column - Select "Edit Column" > "Select Data Type" - Ensure it's set to "Checkbox" 2. Review your formula: - Make sure it outputs a boolean value (true/false) - Use the AI Formula Generator for assistance 3. If the issue persists: - Refresh your browser (Cmd/Ctrl + Shift + R) - If needed, recreate the column with the correct data type If you continue to experience problems, please share your formula so we can troubleshoot further.
Sources: Select Column Data Type Formulas Table columns | Documentation | Clay University
Adam G.
·
·
Bruno R. disregard this question. Problem solved.
Channeled
APP
·
·