How to connect statements with conditions?


I am new in the business and i'm trying to connect some statements on my sheet, so I'll apreciate if anyone can help me with this :)

=IF([PROGRESS]2 = 1, "Green" (Status)


IF today is greater than one day of the [due date]1 , "Red"

IF [STATUS]1 IS GREEN should be green even if due date is greater than "today"

Meanwhile [STATUS] should maintain "Gray"

I hope I have made myself understood

Many thanks!

Best Answer

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 07/05/21 Answer ✓

    Hi @Diego Cardenas 

    Hope you are fine, please try the following formula and convert it to column formt formula:

    =IFERROR(IF(PROGRESS@row = 1, "Green", IF(AND(PROGRESS@row < 1, [due date]@row > TODAY()), "Gray", "Red")), "")

    the following screenshot shows the result

    PMP Certified

    [email protected]

    ☑️ 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!