using a COUNTIFS formula and @row

Ryan Doyle

Hello

I have a cross sheet formula grid, where i am trying to count multiple ranges and multiple criteria. My formula is =COUNTIFS({Group}, "Playout", Show@row, {Action}, "All Call") and I get an Incorrect Argument Set error

The 'Show@row' piece is meant to not have to do individual formulas for over 130 shows. I'd like to count when Group = Playout, Action = All Call for the Show listed on that row (to which there is a Show Name column in my source sheet that would match this Show column in my metric sheet)

Appreciate any assistance that can be provided

thank you

Ryan

Kelly Moore

Hey @Ryan Doyle

It's difficult to tell from your screenshot what range {Group} refers to and if "Playout" is a valid response and/or correct syntax. The same with {Action} and "All Call". I'll assume they are. I can see you are missing a range for your {Show}. Add that cross sheet reference. If this formula doesn't work, please provide more data in your screenshots so I can verify the rest of the terms in your formula.

=COUNTIFS({Group}, "Playout", {Show}, Show@row, {Action}, "All Call")

Does this work for you?

Kelly

Kelly Moore

Hey @Ryan Doyle

It's difficult to tell from your screenshot what range {Group} refers to and if "Playout" is a valid response and/or correct syntax. The same with {Action} and "All Call". I'll assume they are. I can see you are missing a range for your {Show}. Add that cross sheet reference. If this formula doesn't work, please provide more data in your screenshots so I can verify the rest of the terms in your formula.

=COUNTIFS({Group}, "Playout", {Show}, Show@row, {Action}, "All Call")

Does this work for you?

Kelly

Ryan Doyle

Thanks Kelly!!! The suggest formula that you provided DID work! I swear that I tried that yesterday and it didnt work. I've had that happen a couple times in Smartsheet where a formula provides an error but then later on it works. Interesting. But thank you again!