Looking to count how many 'scheduled' statuses we have in 2023 by month.

PKane ✭✭✭✭
edited 08/24/23 in Formulas and Functions


I'd like my formula to look at my AC UPS Scope sheet (source sheet) and count how many scheduled statuses we have by month in 2023.

This is what I have assembled thus far - it keeps coming back as #unparseable.

I probably have it far from correct at this point - any help in correcting/pointing in the right direction would be greatly appreciated.

=COUNTIFS({AC UPS Scope - LFCM Core OPCO}, "NSP", {LFCM OT AC UPS Year}, "2023", {LFCM OT AC UPS Status}, “Scheduled”, [INITIAL DATE]:[INITIAL DATE], IFERROR(MONTH(@cell), 0) = 1)

The source sheet:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!