Please help!if certain cells are blank, return to specific answer

If only Financial Risk is filled out AP status should be "1 star"

If GPS Recommendation are filled out AP status should also be “3 points”

If all 3 successor columns are filled out the AP status should be "5 Star"

Thanks a lot.

Best Answer

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Happy to help!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!