Formula Help

This discussion was created from comments split from: COUNT COLLECT.


  • Trevor S.
    Trevor S. ✭✭
    edited 08/07/23

    Hoping this community could help me out.

    Using the Project Management Office template out of the box (portfolio metrics sheet to be exact) - however for 'In Progress' project status' we have added a few more - "Blocked" and "In Closing." I'm trying to get the standard formulas for the RAG status' to update accordingly but I'm missing something; I keep receiving #UNPARSEABLE.

    The formula for Green, initially, only accounts for "In Progress." I would like it to also consider the above 2 ("Blocked" and "In Closing").

    Thank you to all in advance. Much appreciated!

    Update - is this accurate:

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Try this:

    =COUNTIFS({Project Status}, OR(@cell = "In Progress", @cell = "In Closing", @cell = "Blocked"), {Project Category}, @cell = High$1, {Schedule Health}, @cell = $Label@row)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!