Formula to check if a cell contains "No" or isblank

Christina C
Christina C ✭✭
edited 08/02/23 in Formulas and Functions

This is probably so simple but I am struggling with my if and isblank, or maybe I don't need isblank and need just "" empty quotes. The Column title is "Added to CRM" and it can contain Yes, No, Revised or blank.

I would like to check a cell and if it contains either the word "No" or is blank return a phrase like "Open". If it contains any other word I don't care.

Help! Thank you.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!