PI Formula

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

How Can I Calculate the Number of Hours between Two Different Time Formula Values?
I have a form that collects times of day, into a sheet via a dropdown List of times (9:00 AM, 9:30 AM, 10:00 AM, ect). I have converted these values into a time using the TIME function. So now I have 4 columns: Start Time (dropdown list value from the form) End Time (dropdown list value from the form) Start Time 12 Hr…
Automatic Phase from WorkBreakdown
Hello all! I'm modifying the Simple Portfolio Work Breakdown Schedule and having a little trouble. I like the way the Work Breakdown structure works but I'd really like an automatic way to track which Phase something is in. I know I could just add a column and manually select which Phase tasks and sub tasks are in, but I'm…
How to calculate NPS Score from Smartsheet Sheet
Hello, I have tried to calculate our NPS score, but am getting either UNPARSEABLE or 0. What am I doing wrong here? I've tried this formula (NPS Score 1): And this one (NPS Score 2):