Newer to Smartsheet, trying to build metrics around ranges of data

MichelleR

Okay here is what is working for me:

What I really want to count is this:

as soon as I add in a range of criteria, it returns a sum of 0 - having trouble figuring out if there is a better way to write this out - the statuses are formatted exactly like this on my source sheet. Any help would be greatly appreciated.

Genevieve P.

Hi @MichelleR

If I'm understanding you correctly, you want your COUNTIFS formula to count the rows that have the current Change Category and any of the selected statuses.

If so, try adding in an OR statement, like so:

=COUNTIFS({status}, OR(@cell = RR2, @cell = RR3, @cell = RR4, @cell = RR5), {change category}, RR@row)

Another way to do this would be to add multiple COUNTIFS statements together:

=COUNTIFS({status}, RR2, {change category}, RR@row) + COUNTIFS({status}, RR3, {change category}, RR@row) + COUNTIFS({status}, RR4, {change category}, RR@row)

...and so on.

Cheers,

Genevieve

MichelleR

@Genevieve P. thank you so much!! this was super helpful and yielded the needed result!

Genevieve P.

Awesome, I'm so glad to hear it! 🙂