make a cell only show once a date has been triggered
how do I make the 'sla status' symbol only appear once 14 day planning SLA has been populated with a date.
currently have =IF([14 Day Planning SLA]@row < [Accepted On]@row + 15, "Green", IF([14 Day Planning SLA]@row > [Accepted On]@row + 14, "Red")) to populate the status column
Best Answer
-
HI @Jay rogers
I would have it check if the 14 Day Planning SLA cell is blank and respond accordingly:
IF(Isblank([14 Day Planning SLA]@row),"",IF([14 Day Planning SLA]@row < [Accepted On]@row + 15, "Green", IF([14 Day Planning SLA]@row > [Accepted On]@row + 14, "Red")))
Hope that helps
Thanks
Paul
Answers
-
HI @Jay rogers
I would have it check if the 14 Day Planning SLA cell is blank and respond accordingly:
IF(Isblank([14 Day Planning SLA]@row),"",IF([14 Day Planning SLA]@row < [Accepted On]@row + 15, "Green", IF([14 Day Planning SLA]@row > [Accepted On]@row + 14, "Red")))
Hope that helps
Thanks
Paul
-
yes it worked ! thank you
-
hi @Paul McGuinness
trying to use the same outcome on this sheet but keep getting incorrect.
I am trying to get the status to not appear until 'actual date' column has a value.
=IF([Verify and Review Rack Layout actual date]@row < [NEA Date]@row - 41, "Green", IF([Verify and Review Rack Layout actual date]@row > [NEA Date]@row - 42, "Red"))
-
HI @Jay rogers
This should do that
=IF(Isblank([Verify and Review Rack Layout actual date]@row),"",IF([Verify and Review Rack Layout actual date]@row < [NEA Date]@row - 41, "Green", IF([Verify and Review Rack Layout actual date]@row > [NEA Date]@row - 42, "Red")))
Hope that helps
Thanks
Paul
-
Thanks for helping it does work !
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!