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