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

Answers

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

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

    1.jpg


    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"

    · Share on FacebookShare on Twitter
  • Maryjo Reyes
    Maryjo Reyes ✭✭

    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.

    1.png

    Thanks.

    · Share on FacebookShare on Twitter
  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

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


    1.jpg


    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"

    · Share on FacebookShare on Twitter
  • Maryjo Reyes
    Maryjo Reyes ✭✭

    @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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!