ACOS Function does not exist

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!

Find more posts tagged with

Formulas

Accepted answers

All comments

KPH

Hi @Alkan Air YXY Ops

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.