Status and Date Formula

Hello,

I have been out of the game for a bit and having trouble writing this formula. Trying to collect monthly data for completed calls. Currently I have my formula written as this:

=COUNTIFS({Status}, ="Complete", {Initial Call}, AND(IFERROR(MONTH(@cell, 0)) = 1))

Getting the incorrect Argument error. Can't figure out what I am doing wrong here.

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!