Percentage change between two columns
Hello. I am trying to create a formula that will give me the increase or decrease between tickets in a quarter. I have the formula to count quarterly. I just need something to give me the variance between tickets during a quarter.
Q1 = 130 Q2 = 340 QoQ% = ?
Tags:
Answers
-
=[Q2]@row/[Q1]@row ?
-
or if you want it to based on a positive negative scheme you could use
=1 - [Q2]@row/[Q1]@row
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!