Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Year over year with Year-to-date calculation

Tina Rubin
Tina Rubin ✭
edited 12/09/19 in Archived 2017 Posts

Id like to create a formula to calculate year to date 2016 vs 2017

 

Example  2016 - I have total  of monthly sales for all 12 months (jan-dec)

2017 I YTD have sales for Jan- march

I want to look at Jan-march ytd 2016/vs 2017 % change year over year

 

Thanks for any help!

Tina

 

 

 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Shaine Greenwood
    Shaine Greenwood Employee

    Hi Tina—

    Not quite sure if I'm getting this right, but I believe YTD returns % is ((CURRENT - PREVIOUS) / CURRENT) * 100

    I'm getting this info from Investopedia so correct me if I'm wrong.

    You can do this in Smartsheet with a formula like the following: 

    =(SUM(Sales13:Sales15) - SUM(Sales1:Sales3)) / SUM(Sales1:Sales3)

    Imagine these ranges as ((2017 sales) - (2016 sales) / 2017 sales)

    Instead of the * 100, format the column that contains your formula for % by clicking the % button in the left toolbar.

    Keep in mind that you'll need to change the cell references to the column names of your sheet.

    More on the SUM function in Smartsheet can be found in our Help Center: https://help.smartsheet.com/function/sum

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories