nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

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

Kristin McClinton

=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

Project Management

Comments

Kelly Moore

Hey @Kristin McClinton

I moved a few parentheses around.

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

cheers

Kelly

Sign in to join the conversation!

Quick Links

Trending discussions

Fields dropped from form logic when duplicating a form
When I duplicate a form, Heading fields are dropped from the conditional logic in the copy. In the original, a dropdown's "then show the following fields" list includes two Headings. In the duplicate, the condition and the other fields carry over, but the Headings are missing. Screenshots of both are attached. Has anyone…
Smartsheet Basics - View only access
Can you send someone in your company view only access to a smartsheet sheet who does not have a smartsheet license? I need to send a coworker view only access to a comms plan I created in smartsheet.
Duplicate account
I have a business account and have had for 6 years or so. I had to reset my google password manager this week due to an issue with a workspace account. I've just tried to login to smartsheet using 'login with google' and its made me a new smartsheet account with the same email. I've tried deleting this free account but I…