Formula Error

BESP10
BESP10 ✭✭✭✭✭✭

Good afternoon,


I dont know what I am doing wrong, but every tikme I try this formula I get this erros


=SUM([Budget Unload]@row, [Budgeted Python Per Piece]@row, [Budgeted Fit Up]@row, [Budgeted Weld]@row, [Budgeted Paint]@row, [Budgeted Load]@row) * 0.1)/60


Anybody know where I am not doing the syntax correctly?



Best Answer

  • Meagan Harte
    Meagan Harte ✭✭
    edited 11/03/21 Answer ✓

    Hey there BESP10! Your syntax is off I think. I messed around with it and I got a value - I think you needed an extra parenthesis at the beginning. 😉

    Try this: =(SUM([Budget Unload]@row, [Budgeted Python Per Piece]@row, [Budgeted Fit Up]@row, [Budgeted Weld]@row, [Budgeted Paint]@row, [Budgeted Load]@row) * 0.1)/60



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!