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

Public sector - public records requests
Hello, we are a public sector organization, and any information entered into Smartsheet is subject to open records requests. Is there anyone else who has to search and provide data in Smartsheet to the public? If so, how do you provide that information? If it is a project plan, do you export to a PDF? Does that include the…
Sharing of Smartsheet
When creating a Smartsheet/not workspace, we want to automatically share admin rights and editor rights with the same people on every sheet. Is there a way to automatically do this, without manually entering the names on share button after creation? thanks Amy
Retrieving a Smartsheet
Hi everyone, Is there any way to retrieve a previous version of a Smartsheet? I accidentally deleted a very important column from my Smartsheet. I really only need that one column back because I haven't been able to recreate the formula. Thanks Freda