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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!