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

Maryjo Reyes

Bassam Khalil

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

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.

Thanks.

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

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.