Symbols Formula
Hi all! I am trying to set a IF forumula for symbols changing colors driven by multiple columns.
=IF([BYT RELEASE DATE]@row = 0, "Red", IF([BYT ORDERED]@row = 1, "Yellow", IF([OPEN ISSUES]@row = 1, "Blue", IF(RECEIVED@row = 1, "Green"))))
I can not seem to get the right syntex. Help is appreciated ☺
Best Answer
-
Hi @kaowser
I think you need to tie all your columns together in your formula for it to work? Try
=IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 0, [OPEN ISSUES]@row = 0, [RECEIVED]@row = 0), "Red", IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 1, [OPEN ISSUES]@row = 0, [RECEIVED]@row = 0), "Yellow", IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 1, [OPEN ISSUES]@row = 1, [RECEIVED]@row = 0), "Blue", IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 1, [OPEN ISSUES]@row = 1, [RECEIVED]@row = 1), "Green"))))
Answers
-
Hi @kaowser
I think you need to tie all your columns together in your formula for it to work? Try
=IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 0, [OPEN ISSUES]@row = 0, [RECEIVED]@row = 0), "Red", IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 1, [OPEN ISSUES]@row = 0, [RECEIVED]@row = 0), "Yellow", IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 1, [OPEN ISSUES]@row = 1, [RECEIVED]@row = 0), "Blue", IF(AND([BYT RELEASE DATE]@row <> "", [BYT ORDERED]@row = 1, [OPEN ISSUES]@row = 1, [RECEIVED]@row = 1), "Green"))))
-
Thank you @Gillian C!! that worked!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 429 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!