SUM and DIVISION

Marilen.Navarro103391

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

MCorbin

=([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

MCorbin

=([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