Return a cell's value in a formula when 0% is showing in the "completed" column.


I am trying to write a formula that will return the number of estimated hours still needed on a project. I have an "Estimated Hours Needed" column and a "Percent Completed Column".

My original calculation of

=SUM([Estimated Hours Needed]@row * [Percent Completed]@row)

worked for rows that had a percentage other than 0% in them. I tried another formula to tell it to see if the field had "0" in it - and if it did, use the number from the "Estimated Hours Needed" column, but if it had a number larger than "0", do the calculation of multiplying "Percentage Completed" against "Estimated Hours Needed". That formula returned an #Unparseable error for the row I put it in

Below is the formula I used:

=IF([Percent Completed]@row = "0", [Estimated Hours Needed@row], IF([Percent Completed]@row >"0", SUM([Estimated Hours Needed]@row * [Percent Completed]@row)))

What am I doing wrong?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!