COUNTIFS with FIND and ISDATE

EmilyG
EmilyG ✭✭
edited 03/31/23 in Formulas and Functions

Hello,

I'm trying to create a COUNTIFS formula to count cells in a separate sheet that contain 000 in their 6 digit ID number column and have a date in a different column.

The formula below is giving an error:

=COUNTIFS(({Dashboard Source Sheet Store #}, FIND("000", @cell) > 0), {Dashboard Source Sheet AIC Date}, ISDATE(@cell))

Thanks in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!