How do I "square" a formula

This is the excel formula which includes to square the equation and then multiply (last 2 functions). This is an invalid operation in Smartsheet (^)... how can I make this work?


=IF(ISBLANK([Operator Height]@row), "", IF([Operator Height]@row = 0, 0, IF([Operator Repeat]@row = 0, 0, [Operator Height]@row / [32/64]@row / [Operator Repeat]@row) ^ 2 * 246744))

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!