Health Column
Hi Team,
I'm using a formula to track the health of all tasks and using the standard "Green", "Yellow" and "Red" symbols to show at risk items. I've used the sheet as a template and new date ranges are not yet filled out, but the symbol Red shows up. How do I get this to go away until the task is actually at risk?
Thank you
Best Answers

Hi @tsandluck
The color of the dot is controlled by a formula within the cell. This is probably an IF formula. If you doubleclick on the cell you will be able to see and edit the formula (unless it is a column formula, in which case you need to rightclick and select "Edit column formula").
To change how the colors are displayed you need to change the formula.
If it is showing as red when there is no date, it could be that "red" is the default response if the logic to turn it green or amber is not true. You can either edit the part that turns the red on, or you can switch the entire formula off for blank dates by adding another IF at the start to say if the date is blank, do nothing. It's hard to help precisely without seeing your sheet or formula. The additional step to stop the formula from doing anything if the date is blank would be:
=IF(ISBLANK(Date@row), "", original formula)
This means if the cell in the current row in the Date column is blank return "" (essentially nothing). If not then do whatever the original formula says.
Note  you need to have the closing parenthesis at the end, after any parentheses that are in your original formula. You can change the column name of Date to whatever your date column is called. If this has spaces, you need to put [ and ] around the name, for example:
=IF(ISBLANK([State Date]@row), "", original formula)
I hope that helps.

That worked, thank you very much!
Answers

Hi @tsandluck
The color of the dot is controlled by a formula within the cell. This is probably an IF formula. If you doubleclick on the cell you will be able to see and edit the formula (unless it is a column formula, in which case you need to rightclick and select "Edit column formula").
To change how the colors are displayed you need to change the formula.
If it is showing as red when there is no date, it could be that "red" is the default response if the logic to turn it green or amber is not true. You can either edit the part that turns the red on, or you can switch the entire formula off for blank dates by adding another IF at the start to say if the date is blank, do nothing. It's hard to help precisely without seeing your sheet or formula. The additional step to stop the formula from doing anything if the date is blank would be:
=IF(ISBLANK(Date@row), "", original formula)
This means if the cell in the current row in the Date column is blank return "" (essentially nothing). If not then do whatever the original formula says.
Note  you need to have the closing parenthesis at the end, after any parentheses that are in your original formula. You can change the column name of Date to whatever your date column is called. If this has spaces, you need to put [ and ] around the name, for example:
=IF(ISBLANK([State Date]@row), "", original formula)
I hope that helps.

That worked, thank you very much!

That's great, I'm glad I could help.
If you can, please mark the answer as accepted so anyone else looking for the same thing can find it.
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives