Keep the text in a cell if is not blank but if it's blank then add "N/A"
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
-
=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.
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!