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

EmilyEchevarria

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

Mike TV

@EmilyEchevarria

=IF(ISBLANK([Column1]@row), "N/A", [Column1]@row)

This will look at the column/row you point it to and if it's blank write N/A and if it's not blank it will write what was written in that location.

DKazatsky

Hi @EmilyEchevarria

This can be done with a Workflow as such...

Where I have "Primary Column", you use the appropriate column. You can change "Run workflow" to best suit your needs.

Hope this helps,

Dave