Welcome!

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

Sheets

Finance

Formulas

Support

I moved a few parentheses around.

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

cheers

Kelly

Comment Notifications - Who all gets notified?
First time posting, long time fan of SmartSheet. 🥰 We have a group of people that need to get tagged consistently in comments for email notifications, and we want to cut down on having to "tag" in the same conversation/comments section. My question is: What determines a conversation that "I am following", where I am not…
Branching Logic in Repeating Forms
I am building a form with a repeating feature for study drugs. The form includes 10 questions about the first drug, with branching logic in 2 of those questions. If the answer is YES, a text field appears for more information. This works fine for the first drug. The last question asks if there is another drug. If the…
Can I view sheet-level comments on a report?
I have a sheet that already has a "Latest Comment" column, and I can easily pull the row-level comments onto a report using this column. I take this report and use it as a dashboard widget so people can see the latest comments from the sheet all together. However, this sheet will also have sheet-level comments. Is there a…