How do I calculate the yearly revenue?

I have my sales pipeline in a sheet. It includes the first billing date in format "MM/DD/YY", total billable months and monthly billable amount. How do I calculate the revenue for each year? Most of our contracts are 36 months long. I can't seem to figure out how to pull the revenue for each year. Thank you in advance for your help.


  • Julie Fortney
    Julie Fortney Overachievers

    @MHill ,

    How do you want to display the revenue for each year? Would you have a column for each year, showing the revenue for each contract during that year? You could then have a sheet summary field showing the total revenue for all contracts each year.

    Also, do you bill on the same date of each month? In the example below, would the next billing be on 7/19/23?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!