I need help creating a formula for a Health status (RGY).

SLloyd

SLloyd ✭

03/20/24 in Formulas and Functions

The Health symbols should be based on the % Column and the Leadership Assessment( pain level symbols).

Can you help?

0 ·

Answers

Nick Korna ✭✭✭✭✭✭

03/20/24

Hi @SLloyd,
It's absolutely possible to do something for this, but what criteria do you want to use?
E.g. if % Complete is greater than X% and Leadership Assessement is above a certain level = green

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

SUMIFS formula syntax
Hi, I believe I'm needing help with the syntax for the SUMIFS formula. See the below photo with example data: I am wanting to total the revenue generated for each department (category) and sub department (topic) only if the status is labeled "Won" - which the above screenshot would not be included in the total. The "Topic"…
Dynamic "Week Of"
Hello, Is there a way/formula I could write to get a single cell to display a dynamic "Week of XX/XX" regardless of what day today is? I want to display it for a report that will always be the previous Monday-Sunday and will roll forward the next Monday.
Return Multiple Values from a Lookup of Multiple Values
I have a training feedback form, and classes have multiple instructors. When the student picks multiple instructors, I need to look up the corresponding email for each instructor, usually only 2. you can see from my screen shot, I am getting an error if there is 2 to lookup, is this even possible or what is a recommended…