ACOS Function does not exist

Alkan Air YXY Ops

Hello,

I have created a Smartsheet to collect operations data and I'm now trying to add a formula in there to automatically return a result using a formula.

In other words, cell B1 and C1 get filled out through a form, and when that happens I want D1 to show a result using a formula which includes ACOS (Arccosine) and SQRT (Square Root) functions. However, these functions do not seem to work in Smartsheet.

Is there a solution to my problem I do not see?

Thank you!

KPH

Hi @Alkan Air YXY Ops

I'm not sure about trigonometry, but for square root you could try =[column]1 ^ 0.5