Clay Icon
Join the Community
02 Support

Checkbox Column Formula Error in Clay: Boolean Conversion Issue

Avatar of Adam G.Adam G.
·
·

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?

3 comments

  • Avatar of Channeled
    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.

  • Avatar of Adam G.
    Adam G.
    ·
    ·

    Bruno R. disregard this question. Problem solved.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·