Hi folks, just a quick announcement about a new formula article that walks through how to check for missing field values, and display them conditionally in a formula field.
Here’s an example from the article of what the end result looks like.
You can use and modify this approach for any number of workflows, so we hope it’s helpful! If you have any requests for support articles around formulas (or anything else!), just let me know :thumbs_up:
You had one extra parenthesis at the end – but also, you have a mixture of “curly” quotes and “straight” quotes in your formula text. Airtable’s formula editor doesn’t like “curly” quotes and will throw an error if they are in your formula.
Try copy-pasting this version of your formula where I’ve removed the extra parenthesis, and made sure all the quotes are of the “straight” variety: