How do i do a Date range and countifs formula

I am new to formulas and need some help with the below:

I have 3 columns called 'campaign', 'actual delivery date' & 'statics'.

I need to create a formula that shows the count of statics per month for every campaign.

I.e. if the campaign is 'b' and the deadline is 1/3/23 it will show me how many statics we did for campaign b in January.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!