Countifs - Collect, Index, Match?

Nick Allgauer
Nick Allgauer ✭✭✭✭
edited 02/22/21 in Formulas and Functions

Hi, I need to count data based on a set of criteria. Here's what I have so far:

=COUNTIFS({Project}, $Max$182, {Last Day Worked}, <2 / 1 / 2021, {Role2}, [Primary Column]@row)

Here's my criteria. Count if:

1) project matches what's in Max182

2) last day worked is less than Feb 1st

3) Role matches what's in the primary column

Any suggestions? It's giving me #INVALID OPERATION. I wonder if I need something more complex like collect, index, match.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!