Calculating overtime hours

I have the below columns for standard flat rate, travel, and 3 overtime columns (O/T hrs). I want to calculate the O/T hours, according to which overtime column the hours are in, under Total O/T. Appreciate help with getting the formula right.

Best Answer

  • Michelle Maas
    Michelle Maas ✭✭✭✭
    edited 05/28/21 Answer ✓

    Hi @Andrée Starå, thanks for responding. It came up with = #UNPARSEABLE. Had a review of the formula and changed to below, then it worked. Thanks for getting me on the right track.

    =[O/T Hrs(1)]@row * 1 + 1.5 * [O/T Hrs(1.5)]@row + 2 * [O/T Hrs(2)]@row


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!