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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!