Converting =SUMPRODUCT from Excel to Smartsheet
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
Check out the Formula Handbook template!