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

=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")))

Find more posts tagged with

Sheets

Finance

Formulas

Support

I moved a few parentheses around.

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

cheers

Kelly

Does anyone else find Collections worthless?
I find Collections worthless, and am wondering if others feel the same. If these are replacing WorkApps I have so many questions. The biggest gap by far (IMO) are managed references. If the whole point of Collections is to control access and only share certain things, then this is not going to work for me. For example, I…
Can input from one form separate to two rows when they input to sheets based on conditions?
We currently ask people to select one form per one need for referral into a program. For example, I want to submit a referral to a community health team and another one to behavioral health team. I need to submit two separate forms because each form submission will create one row to master task list where it then auto move…
Tracking changes
Hi, I'm wondering how to track changes that other team members have made in our shared sheets, if someone could let me know how to do this or if there's a report I can pull down, that'd be great.