Need Help Calculating % Change (increase or decrease) Between Two Numbers

Answers

  • John_Anetrella
    edited 03/19/24

    I am tracking project start dates and slippage

    I want to determine the percentage increase or decrease between two numerical values

    =[CURRENT QUARTER]1 - [ELT DATE STAT]1 / [ELT DATE STAT]1 * 100

    (FINAL VALUE) CURRENT QUARTER VALUE = 3

    (ORIGINAL VALUE) ELT DATE STAT VALUE = 5


    PERCENTAGE DECREASE SHOULD BE 40% decrease?

    THE ABOVE FORUMLAW YIELDS -97

    WHAT AM I DOING WRONG HERE? COLUMNS ARE NUMERICAL

  • AravindGP
    AravindGP ✭✭✭✭✭

    Hi @John_Anetrella


    You can try this and make the column formatted as a percentage. Since it is a decrease, it will show in the negative.


    ([Current Quarter]@row - [ELT Date Stat]@row)/[ELT Date Stat]@row

    Thanks,

    Aravind

    Reach out for any help on licenses, configuration, or training

  • I forgot the ) after the first function. Works fine now, thanks. Didn't need @row

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!