Percentage Increase/Decrease

Hi there, I've looked at some other answers in the community but none seem to work for me.

I'm trying to determine the % increase or decrease of values Year Over Year. Here's an example:

THIS YEAR, we have a sheet that shows $125,000 in revenue. This time last year on a separate sheet, we showed $225,000. How do I create a formula to calculate the difference in % increase/decrease?

THIS YEAR sheet has column Actual QTD

LAST YEAR sheet has column Actual QTD

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!