PI Formula

Options

Majid Kayani

Majid Kayani ✭✭

10/04/22 in Formulas and Functions

Hi,

i was wondering if there is a option to use PI in a formula within Smartsheet's.

i am trying to get the below formula to work it currently working in excel.

0.19793488158659*180/PI()

any help will be great to get this to work on smartsheets.

0 ·

Answers

Michael Culley ✭✭✭✭✭

10/05/22

I don't believe smartsheet has pi built in. Could you not just take the first x digits of pi?

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Sum Multiple Criteria
I'm looking to sum the total in the CS Error Cost column anytime the Responsibility column equals CSC, ISG or UAL. I've attempted different nesting versions of the SUMIF and SUMIFS but keep getting an error. Below is one example of what I attempted. =SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility,…
IFERROR Formula Not Working
Good day, team. I have a formula that works as intended, which takes the latest row of children data and inputs that as the value. That formula is: =(INDEX(CHILDREN(), COUNT(CHILDREN()))) and produces the following results: However, if there is no data in the children cells it gives me an "Invalid Column Value" as shown…
Sum of child rows multiplied by other row.
Hello Community, Can the sum of child rows that are individually multiplied be achieved without the use of a helper column? I would like to be able to detail the total sum of the child rows [March 2025] multiplied by [Rate] without the use of a helper column. I =SUM(CHILDREN([March 2025]@row ) * CHILDREN(Rate@row ))…