If Blank in formula Help!

I have setup a formula =IF(AND([WO # if applicable]@row = "N/A"), "No", "Yes") in a Notify Process Docs column, that when a N/A is entered into the WO # if applicable column returns a No value. Any other value will return it to Yes, triggering a notification to be sent to certain individuals. I am struggling on the formula to return a "No" value if the cell is blank.

Thank you in advance for your assistance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!