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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    There's the issue. In your formula you have "CNJ", but the actual data is "CCNJ" (with two C's). Instead of "hard coding" the source criteria, try using a cell reference. This will make the formula more dynamic so you can just drag-fill it down for the rest of the rows and it is one less place to accidentally make a typo.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!