Need help on this. Assign no symbol automatically if Status is blank. Thanks

Options

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 02/15/21
    Options

    Hi @Maryjo Reyes

    Hope you are fine, please try the following formula and convert it to a column formula.

    =IF(ISBLANK([Aging (PDMG)]@row), "", (IF([Aging (PDMG)]@row > 3, "Red", (IF([Aging (PDMG)]@row <= 3, "Green")))))


    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"

  • Maryjo Reyes
    Options

    Hi @Bassam.M Khalil, thanks for your reply. I'm referring to the Status if blank. Even if the Status is blank the Aging column will have a value. Using your formula, SLA column will have no symbol.

    Thanks.

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    @Maryjo Reyes

    Ok i understand your issue now, please try the following formula.

    =IF(OR(ISBLANK([Aging (PDMG)]@row), (ISBLANK([Status ( PDGM )]@row))), "", (IF([Aging (PDMG)]@row > 3, "Red", (IF([Aging (PDMG)]@row <= 3, "Green")))))



    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"

  • Maryjo Reyes
    Options

    @Bassam.M Khalil, don't know if it's possible, the formula should be the SLA column has no symbol if it has no values or blank at all.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!