Please suggest me adding these hrs values in above coloumn

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????


Best Answer

  • Antonio Figueroa
    Antonio Figueroa ✭✭✭✭✭✭
    Answer ✓
    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)))


    Of coarse Column2 would be your Column Header


    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

Answers

  • Antonio Figueroa
    Antonio Figueroa ✭✭✭✭✭✭
    Answer ✓
    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)))


    Of coarse Column2 would be your Column Header


    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

  • Rakesh Lavishetty
    Options

    HI @Antonio Figueroa ,

    Hope your are doing great!!!

    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!