Countifs Date range clash formula with Distinct value criteria


Hi all,

=COUNTIFS(Start:Start, Start@row >= @cell, Finish:Finish, Finish@row <= @cell, 👤:👤, 👤@row)

It returns a 1 as there is only 1 instance, but I would like it to return 2 because LM appears twice on the same date. This column allows multiple people to be selected.

I was thinking maybe of combining a countM or distinct function with formula above, but I don't know how.

Any help much appreciated,

Many thanks,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!