Date formula Question

Have a summary sheet for my tracking sheet and am looking for a formula that tells me how many of a source/type (01_CNJ) have a date in a specific column.

Current formula (#unparsible):

=COUNTIFS({REFSheet_Source}, "01_CNJ", {REFSheet_Date}, IFERROR(2023(@cell), 0) = 2023)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!