Mutliplying mutiple columns + multiplying mutiple columns
Smartsheet does not like multiplying 0's so I need some help.
I can get around this by adding more columns in but that will be painful with 13 similar sheets! lol There has to be a way to do this without additional columns.
There are times when the MU columns are all 0, but there are REP gallons used. I get an "invalid operation" only when there are 0s involved. I still need it to multiply though.
=IF([1310 MU Gallons Used]@row = 0, "", ([1310 MU lbs per gallon]@row * [1310 MU Gallons Used]@row * [1310 MU Price per lbs ($)]@row)) + IF([1310 REP Gallons Used]@row = 0, "", ([1310 REP lbs per gallon]@row * [1310 REP Gallons Used]@row * [1310REP Price per lbs ($)]@row))
Help Article Resources
Check out the Formula Handbook template!