Sum a revenue column YTD Based on a subscription start date (or month) and the current month.

Options
Paula_
Paula_ ✭✭✭✭

I have tried a variety of formulas in my sheet summary to show a YTD value of revenue based on a subscription start date and the current month.

Can anyone point me in the right direction of how to make this possible?

I have created a "month" column for the subscription date as well as today's date

=SUMIFS([EA Net Revenue]:[EA Net Revenue], [Month:Month], <=[YTD Month]:[YTD Month])

Comes back unparsable

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!