Converting =SUMPRODUCT from Excel to Smartsheet

Katrina ✭✭✭✭
edited 06/15/23 in Formulas and Functions

How would I convert this formula to work in Smartsheet?


B93-B137 = Project Type

J93-J137 = [July thru 7/31]$125

I can get the first part using a SUMIF formula: =SUMIF([Project Type]$83:[Project Type]$125, =$[Project Type]@row, [July thru 7/31]$83:[July thru 7/31]$125)

The last Part *(1-($G$93:$G$137) is what stumps me. I need it to calculate the difference of a percentage listed in the cell.

Not sure if this can be done in one formula, or if it will require a helper sheet.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!