SUM and DIVISION

Marilen.Navarro103391
Marilen.Navarro103391 ✭✭✭✭✭
in Formulas and Functions

Can you check my formula for getting the % for the month

It should be add 121-365 Days and Greater than 365 Days DIVIDED by Grand Total

image.png


· Share on FacebookShare on Twitter

Best Answer

  • MCorbin
    MCorbin Overachievers Alumni
    Answer ✓

    =([121-365 Days]@row + [>365 Days]@row) / [Grand Total]@row

    image.png


    If yours wasn't working, I'm guessing you were missing the ( ), right? Without the ( ), Smartsheet would divide this part first: [>365 Days]@row) / [Grand Total]@row and then add [121-365 Days]@row

    · Share on FacebookShare on Twitter

Answers

  • MCorbin
    MCorbin Overachievers Alumni
    Answer ✓

    =([121-365 Days]@row + [>365 Days]@row) / [Grand Total]@row

    image.png


    If yours wasn't working, I'm guessing you were missing the ( ), right? Without the ( ), Smartsheet would divide this part first: [>365 Days]@row) / [Grand Total]@row and then add [121-365 Days]@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!