Filter & Total YTD

Hello,

I'm trying to filter how many YTD programs I've held of a specific program. There is a column with many program names, and a column with Start Dates. How do I find the YTD total of a specific program? This is what I've come up with so far, but it keeps giving me errors.

=COUNTIFS({Program Name Column In reference sheet}, "Program Name", <YEAR(TODAY())

Thanks!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!