Symbol Formula including 2 Columns?
Hi All!
I'm working on a Smartsheet and I need a logic formula to update the symbol color. I have 2 columns that I am using in the formula [2 Signer - Status] [1 Signer - Status].
When the status in either of these cells is "Sent" "Delivered" or "Draft", I would like the color of the symbol to be "Yellow".
When the status is "Declined" or "Voided = Red
When the status is "Completed" = Green.
Below is the formula I'm currently using, but it keeps returning #UNPARSEABLE.
I'm not sure which part I'm messing up.
=if([2 Signer - Status]@row [1 Signer - Status]@row = "Sent" "Delivered" "Draft", "Yellow", If([2 Signer - Status]@row [1 Signer - Status]@row = "Declined" "Voided", "Red", If([2 Signer - Status]@row [1 Signer - Status]@row = "Completed", "Green", "")))
Best Answer
-
Hi @nwilliamsmovement you need to break down the parts and add other formula piece to make it work. I think this should work....
=IF(OR([2 Signer - Status]@row="Sent",[2 Signer - Status]@row="Delivered",[2 Signer - Status]@row="Draft,[1 Signer - Status]@row = "Sent",[1 Signer - Status]@row ="Delivered",[1 Signer - Status]@row ="Draft"),"Yellow",IF(OR([2 Signer - Status]@row="Declined",[2 Signer - Status]@row="Voided",[1 Signer - Status]@row ="Declined",[1 Signer - Status]@row ="Voided"),"Red",IF(OR([2 Signer - Status]@row="Completed",[1 Signer - Status]@row="Completed"),"Green","")))
Answers
-
Hi @nwilliamsmovement you need to break down the parts and add other formula piece to make it work. I think this should work....
=IF(OR([2 Signer - Status]@row="Sent",[2 Signer - Status]@row="Delivered",[2 Signer - Status]@row="Draft,[1 Signer - Status]@row = "Sent",[1 Signer - Status]@row ="Delivered",[1 Signer - Status]@row ="Draft"),"Yellow",IF(OR([2 Signer - Status]@row="Declined",[2 Signer - Status]@row="Voided",[1 Signer - Status]@row ="Declined",[1 Signer - Status]@row ="Voided"),"Red",IF(OR([2 Signer - Status]@row="Completed",[1 Signer - Status]@row="Completed"),"Green","")))
-
**Of note with this if one of the columns has a status that would be yellow and one that would be green the symbol would be yellow because that clause comes first in the formula. If you wanted one color to take precedence over the other you would just need to rearrange the formula. **
-
Thanks Kimberly! This formula worked properly and I was able to get it to do what I needed. 😊
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!