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))
Best Answers

Hi @Elizabeth Aird,
You may need to just do the function X function by typing it out twice instead of using ^2.
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony

Yes. You will need to do
function * function
as Smartsheet does not support the ^ operator.
Answers

Hi @Elizabeth Aird,
You may need to just do the function X function by typing it out twice instead of using ^2.
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony

Yes. You will need to do
function * function
as Smartsheet does not support the ^ operator.

Hi... Smartsheet does support the "^" to use instead of "sqrt" ...
For example, I needed the square root of 16.26 so I typed in the formula "=TPI@row / ([Yarn Count]@row ^ 0.5)" and it worked.
Try it.
ps. Would be easier if Smartsheet Team adds the sqrt function instead.

I had a same question, and found the easy answer. I would like to share it with the team...
So if I want to do a square, for e.g. =9^2, the answer will be 81... and if I want to do square root of 81, then formula will be... =81^(1/2) and result will be 9... same would apply for cube or cube root.
Square root is inverse of Square, so I simply inversed the ^ (raised to), and got the square root. Hope it helps!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!