Count ifs formula



I'm using a smartsheet to track contacts engaged in a multi-year project. I'm trying to count all the contacts engaged in year 1 AND 2 in a sheet summary report and can't figure out how to countifs for this sheet. My column is called "year Engaged" and my fields say either "grant cycle #1" or "grant cycle #2". This is what I have that keeps giving me an error message. What am I doing wrong>

COUNTIFS(YearEngaged:YearEngaged, "Grant Cycle #1, [YearEngaged:YearEngaged, "Grant Cycle #2"])


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!