Formula to add "No" to a blank cell, but leave value if not blank

On a Smartsheet project intake form, I have several Yes or No dropdown selections. If Yes, the user must answer additional questions. If No, they do not and those cells are left blank.

Auditors do not like Blank cells, so I'm looking for a formula to replace those blank cells with "Does Not Apply" but leave a value there if present

The formula needs to essentially do nothing if the User inputs "Yes" in the Business Unit Impacted, then enters values in the other 2 columns.

If they enter "No", I want to formula to return "Does Not Apply" to appease our Auditors.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!