Need help on this. Assign no symbol automatically if Status is blank. Thanks
Answers
-
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")))))
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"
-
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.
-
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")))))
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"
-
@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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!