Hi Support team - Is there a way for me to have a formula column that is "true" if another column returns an error?
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.
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.