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
Answers

Kia ora,
Have you created a metrics sheet to pull the information from both sheets to then do a formula?
KL

I haven't, no... I thought I could just pull values from each sheet in a formula?

Is it just the one cell you want to evaluate from the second sheet?
If so, you could create a crosssheet reference that points just to that one cell! Then you can create your calculation between {this cell} and the one [in the sheet]@row
See: Create cross sheet references to work with data in another sheet
Does that make sense?
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
@Genevieve P. I have tried that yes, but it still gives me incorrect data. Can you perhaps tell me what formula to use to ensure I'm doing it correctly? You can use VALUE A and VALUE B as placeholders, and I can fill them in with my cell info.

No problem!
"Incorrect Data" sounds like your formula may not be able to read your numbers as numbers, but instead sees them as text (e.g. if the "$" sign was manually added instead of using cell formatting). Could that be possible?
Here's a simple formula I used, with {Value A of 20} selecting one cell in another sheet that has the number 20 in it.
If you're still getting an error, can you post the formula you're currently using so I can understand the math you'd like to achieve?
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now 
Thanks so much @Genevieve P. ! I wound up just copying the data and running an easy division formula instead. There were only a few lines from another sheet to reference, so it ended up being easier. Appreciate your help though as always!

No problem! I'm glad you figured out a way to get your desired result 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!