SumProduct formula

hi,

i have task in smartsheet and each task i give factor which amounts 100%.

and each task i give actual % complate.

the problam is when i try to calculate the Weighted average i need to multiply each task in his factor.

if i delete or adding 10 to 50 tasks its Becomes exhausting


in excel its easy by using formula SUMPRODUCT.


any idea to resolve ?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!