Excel formula =SQRT()

Asle Gaarder

I am looking for a similar foruma to =SQRT() in Excel.  Does Smartheet have this feature/function in its formula list?

Travis

Hi Asle, Smartsheet does not have a square root method at this time but we are tracking feedback for formula enhancements and I will submit your vote for adding the SQRT() formula.

 

Thanks! 

David Hall

You can just use =x^.5, where x is the cell you want to square root.  This would transfer between Excel and Smartsheet.

Travis

Great work, David! Thanks for posting 

Asle Gaarder

Thanks:)