Options

Hi,

With help of SUM formulas am unable to add total values with "h". In screenshot, in place of arrow mark i should get 75h(5h+10h+15h+20h+25h). please suggest how to accomplish this????

• ✭✭✭✭✭✭
Options

I would make a helper column between actual hours and estimated hours and add this formula and convert to column Formula

=VALUE(IF(LEN([Column2]@row) = 2, LEFT([Column2]@row, 1), IF(LEN([Column2]@row) = 3, LEFT([Column2]@row, 2)))

Then in the cell that you have your arrow pointing to add this formula

=SUM([Column4]15:[Column4]17) + "H"

and Column4 would be the new column you made.

Let me know if this works

• ✭✭✭✭✭✭
Options

I would make a helper column between actual hours and estimated hours and add this formula and convert to column Formula

=VALUE(IF(LEN([Column2]@row) = 2, LEFT([Column2]@row, 1), IF(LEN([Column2]@row) = 3, LEFT([Column2]@row, 2)))

Then in the cell that you have your arrow pointing to add this formula

=SUM([Column4]15:[Column4]17) + "H"

and Column4 would be the new column you made.

Let me know if this works

• Options

Thanks for your time in writing me.

The formula you have suggested and the way you narrated was absolutely remarkable.

In my case, suggested formula perfectly working, Thanks.

Regards,

Rakesh.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!