make a cell only show once a date has been triggered

Jay rogers

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

Paul McGuinness

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

Paul McGuinness

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

Jay rogers

yes it worked ! thank you

Jay rogers

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"))

Paul McGuinness

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

Jay rogers

@Paul McGuinness

Thanks for helping it does work !