Modify a COUNT(DISTINCT(COLLECT to a COUNTIF(DISTINCT(COLLECT

tgattsh
tgattsh ✭✭✭✭
edited 02/22/24 in Formulas and Functions

So I have this formula which works fine.

=COUNT(DISTINCT(COLLECT({FPR24-INSTALLER}, {FPR24-INSTALL DT}, =Date@row, {FPR24-INSTALL DT}, =(Date@row))))

I want to change it to a COUNTIF but I can't get it to work.

=COUNTIF(DISTINCT(COLLECT({FPR24-INSTALLER}, {FPR24-INSTALL DT}, =Date@row, {FPR24-INSTALL DT}, =Date@row)), {FPR24-Res/Com}, "Res")

It's probably something simple, but I can't figure it out. Any help would be appreciated. Thank you...

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!