Clay Icon

Creating a Formula Column for Error Detection in Spreadsheets

Β·
Β·

Hi Support team - Is there a way for me to have a formula column that is "true" if another column returns an error?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To create a formula column that returns "true" if another column has an error: 1. Add a new column and select "Formula" 2. In the AI Formula Generator box, type: "Return true if [column name] has an error, otherwise return false" 3. Click "Generate Formula" 4. Review the sample output 5. Click "Save Formula" This will create a conditional statement checking for errors in the specified column. You can adjust the formula if needed using IF statements, such as: IF(ISERROR([column name])) THEN "true" ELSE "false" If you need further assistance, click on "Talk to a person" for human support.

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