Keep the text in a cell if is not blank but if it's blank then add "N/A"

Options

Hi everyone,

I'm trying to find a function or formula, where if in one cell, someone log information, leave the information like that, but is there is not log information, add a "N/A". This is for daily entry data, to generate a daily report, where if nothing happened in a section, to automatically add "N/A", but if someone log information, leave the information as it is.

Thank You

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!