Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

IF(Condition Check, Light) Question

✭✭
edited 10/04/22 in Formulas and Functions

I am somewhat a new user to SmartSheet and here is the formula that is confusing me for a while:

=IF([Planned % Completion]@row - [Actual/Outlook % Completion]@row > 0.2, "Red", IF(AND([Planned % Completion]@row - [Actual/Outlook % Completion]@row >= 0.1, [Planned % Completion]@row - [Actual/Outlook % Completion]@row <= 0.2), "Yellow", "Green"))

When "[Planned % Completion]@row - [Actual/Outlook % Completion]@row" is between 10% and 20%, it still showed up green instead of yellow.

Makes me wonder what keeps me up at night...

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

  • I am trying to create a formula that looks at 2 different columns Term Ending Date and Amendment - Ending Date. If column Amendment Date does NOT contain N/A it should return the value in [Amendment -…
    User: "n7teixeira"
    Answered ✓
    15
    2
  • Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up …
    User: "JordivL"
    Answered ✓
    21
    1
  • Hello, I've formula use Workday to count Due date = Start Date @row cell + option days. fx Image below: Start Date is 04/24/25, then added 11 days = Resulted 05/09/25 as Due date. Now, out of curiosit…
    User: "JinwonK"
    Answered ✓
    50
    4