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.

I need help making an at risk formula for the 2 percentage columns.

Hello,

I am very new to smart sheets and am currently creating my first.

Can someone please help me use the above screen shots of the chosen symbols in a formula green being percentage complete is >or= to the percentage that should be complete, yellow being percentage complete is 1-25% < Percentage that should be completed, red being percentage complete is 26-100% < percentage that should be completed.

Hopefully that makes sense, I did attach a screenshot of my barebones smart sheet as I am just staring. Thank you!!

Answers

  • Community Champion

    Hi @MSELLS

    I wouldn't suggest using the selected Symbol set as it is used for decisions and denoted as Yes, Hold, and No. However, if you prefer using it, here's the formula you can use.

    =IF([Percentage Completed]@row >= [Percentage that should be complete]@row, "Yes", IF(1 - ABS(([Percentage Completed]@row - [Percentage that should be complete]@row) / [Percentage that should be complete]@row) > 0.25, "Hold", "No"))

    Thanks,

    Aravind GP| Delivery Manager

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions