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

  • Paul McGuinness
    Paul McGuinness Overachievers
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!