how to calculate the % change, increase or decrease

System
System Employee Admin
in Formulas and Functions
This discussion was created from comments split from: % Variance between 2 numbers.
· Share on FacebookShare on Twitter

Answers

  • kerobi
    kerobi ✭

    I have the same question -- how to calculate the % change, increase or decrease. When I use the ABS formula above, the first cell with that calculation was correct, but the rest of the cell calculations (once I applied the formula down that column) are not accurate (e.g. % change from 20 to 24 is not 17%, which is what the ABS calculation is getting me, it should be 20% ). Very confused and hoping someone much smarter than me can help, thank you!

    · Share on FacebookShare on Twitter
  • James Keuning
    James Keuning ✭✭✭✭✭

    =ABS([Number 2]@row - [Number 1]@row) / [Number 1]@row

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!