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?
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions

@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?
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions

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 🙂
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!