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

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

Can you help?

Answers

  • Nick Korna
    Nick Korna âś­âś­âś­âś­âś­âś­

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!