Symbol Forumula Help Please
I have a sheet where I track the progress of 4 steps for multiple projects. Each project has it's own row and the 4 steps are in 4 separate columns. Each step has a check box and when that step is complete the box is checked which in turn triggers an automation that populates the date each step was checked. I am trying to get a symbol to populate in a new column that shows red for the boxes that are not checked and green for the boxes that are checked.
I came up with the formula below but it's not working. I'm using 1 for checked and 0 for unchecked. Any help would be greatly appreciated!!
=IF([LS Drawing Redlines Complete]@row = 1, "Green", IF([LS Drawing Redlines Complete]@row =0, "Red")))
Best Answer
-
Please disregard - I had 1 too many brackets at the end 🤨
Answers
-
Please disregard - I had 1 too many brackets at the end 🤨
-
Good spot! I'm glad you figured it out.
Just a small note, since you only have two actions (either Red or Green), you can actually just use one IF statement for this.
You could say, if the box is checked then it's Green, otherwise, it would be Red, since if the box isn't checked then it has to be un-checked.
Try this:
=IF([LS Drawing Redlines Complete]@row = 1, "Green", "Red")
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 433 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 280 Events
- 31 Webinars
- 7.3K Forum Archives