IF statement to update "Health" column base on "State" and "End Date"

Hi everyone,

I'm trying to create a formula that: If state is not complete and end date is in the past, then health column will show ⏰

State - Drop Down menu: Complete, In Progress, At Risk, Blocked, Not Start

Thank you in advance!

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Linh Nguyen

    Hope you are fine, please try the following formula:


    =IF(AND(state@row <> "Complete", [end date]@row < TODAY()), "Delay", "")

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!