Trying to connect checkboxes to colors
Hi there-
I am trying to make a "status" column turn green or yellow based on a check box in the spreadsheet.
Basically when the "checkbox a" is checked ("true") I want it to turn my status to "Yellow". When the other box "checkbox b" is checked ("true") I want the status to turn "Green".
Here is what I have so far- =IF(FIND("true", [SOs Created]5), "Yellow", FIND("true", [Job Completed]5), "Green")
Any help would be greatly appreciated!
Thanks!
Comments
-
-
This is working! However, I need the green to happen when both checkboxes are marked true.
So if I check the first box it turns yellow, YAY! But, in order for the other one to make the status green you have to uncheck the first box.
Thanks!
-
Hi Taylor,
Try something like this.
=IF(AND([SOs Created]@row = 1; [Job Completed]@row = 1); "Green"; IF([SOs Created]@row = 1; "Yellow"))
The same version but with the below changes for your and others convenience.
=IF(AND([SOs Created]@row = 1, [Job Completed]@row = 1), "Green", IF([SOs Created]@row = 1, "Yellow"))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andree-
The second one worked!
Thank you so much for your help!!!
Taylor
-
Excellent!
Happy to help!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives