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.
Help Article Resources
Check out the Formula Handbook template!