Nested If SmartSheet Formula For Symbols (R, G, Y)

Kristin McClinton

Kristin McClinton ✭

12/31/21 in Smartsheet Basics

=IF([% Complete]@row < 0.7, "Red", (IF([% Complete]@row = 1, "Green", "Yellow")))

i.e.

=IF(data < number, "TRUE Symbol Text", (IF(data = number, "TRUE Symbol Text", "FALSE Symbol Text")))

Tags:

0 ·

Comments

Kelly Moore ✭✭✭✭✭✭

12/31/21

Hey @Kristin McClinton
I moved a few parentheses around.
=IF([% Complete]@row < 0.7, "Red", IF([% Complete]@row = 1, "Green", "Yellow"))
cheers
Kelly

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

IF {Status} is "X" or "XX" and {Date} is in the coming 90 days
Hello, In the formula below I am asking if the status in a reference sheet is "Pending Submission" or "Pending Approval" then display "No" in a symbol column. I would be very grateful for any best practice on how to structure the formula to add in if {status} is "Pending Submission" or "Pending Approval" and a {Date…
Multiple Selection in drop down or buttons on forms
There should be a way to select multiple options on a form when choosing from a list.
Duplicate Rich Text Widgets to another dashboard
Hi, We have a project that has a SS dashboard with all the updates ("Master Dashboard"). We have another dashboard that would duplicate some of the RT widgets from the Master Dashboard. How can we do this automatically? Trying to avoid duplicated efforts for the same exact content. The content has some rich formatting, so…

Help shape the future of Smartsheet.
Share your ideas and feature requests.