SUM and DIVISION

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


Best Answer

  • MCorbin
    MCorbin Overachievers Alumni
    Answer ✓

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


    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

Answers

  • MCorbin
    MCorbin Overachievers Alumni
    Answer ✓

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


    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!