Empty Cell vs Blank Cell
Is there a way to differentiate an empty cell (cell with no formula or text etc) from a blank cell (Cell with a formula result of "" in it?
The isblank formula doesn't work as it sees them both the same.
My goal is to use an if/then situation to bring attention to rows/cells that have absolutely nothing in it vs ones that have a formula giving the result of "" which is blank, not empty.
Best Answer
-
Hi,
There is no formula in Smartsheet that detects if a cell contains a formula which is outputting nothing (at least as far as I'm aware and with a bit of testing!)
The only thing I can think of is to ensure formulas never output nothing - where they are outputting nothing, put an output of some kind i.e. a period/full stop
You can then detect that and highlight any fields that are genuinely totally empty or are outputting the 'nothing' proxy character.
Might be worth registering this as an enhancement request
Tim
Answers
-
Hi,
There is no formula in Smartsheet that detects if a cell contains a formula which is outputting nothing (at least as far as I'm aware and with a bit of testing!)
The only thing I can think of is to ensure formulas never output nothing - where they are outputting nothing, put an output of some kind i.e. a period/full stop
You can then detect that and highlight any fields that are genuinely totally empty or are outputting the 'nothing' proxy character.
Might be worth registering this as an enhancement request
Tim
-
@AnthroTim Thanks for the reply... that's what I was thinking. I was trying to avoid adding a character like a "." or something similar because I already had tons of formulas saying things like "=if(isblank(.... but I did add "-" to my results in lieu of the "" I had... just had to go back and fix all the others. Was hoping but I expected it didn't exist.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!