Need to add additional Criteria to Metric Formula

I have a Metrics Sheet (named "Escalation Metrics") where I could up all my metrics (most are words rather than numbers. so this allows me to easily create a dashboard based on data that does not contain numbers. My current formula is:

=COUNTIF({Type of Escalation}, [Metric Name]@row)

And I want to add the criteria that the "Status" must be "Open". When I try to add this to the end:

, {Status}, ="Open") I get error messages. That last portion was taken from an Aging metric, which requires one of the criteria to be that the status is Open.

Thanks in advance!!!!!

Sherry Fox

Business Process Analyst 3 | C5ISR Group

HII | Mission Technologies

EAP | Mobilizer | Automagician | Superstar | Community Champion

Original Smartsheet Profile: @Sherry Fox

Best Answer

  • Sherry Fox
    Sherry Fox ✭✭✭✭✭✭
    Answer ✓

    @Paul Newcome ,

    I have been re-doing the formula since I last replied. It finally worked!!!!! My corrected formula is:

    =COUNTIFS({Type of Escalation}, [Metric Name]@row, {Status}, ="Open")

    The previous one I did that resulted in Unparsable was the following. I have bolded the ")" which was the difference and caused the problem. Thanks for your help!!!!!

    =COUNTIFS({Type of Escalation}, [Metric Name]@row), {Status}, ="Open")

    Sherry Fox

    Business Process Analyst 3 | C5ISR Group

    HII | Mission Technologies

    EAP | Mobilizer | Automagician | Superstar | Community Champion

    Original Smartsheet Profile: @Sherry Fox

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!