Count if Formula help for a count within a date range


Here is my current formula -

=COUNTIFS({Retail MarketingLead}, [Primary Column]@row, {Actual in MarketStart Date}, @cell <= TODAY())

I need to capture the count for April 1, 2020 - March 31, 2021

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!