Adding the number pi (π)

Nik Fuentes
Nik Fuentes ✭✭✭✭✭
edited 06/23/22 in Formulas and Functions

I'm using a sheet that needs to calculate things using circles and therefore requires the use of the number pi (π). Is there a way to express π in Smartsheet without typing it out to the full default sigfigs? 'Cause I'd rather not do that, even in sheet summary. While we're at it I'd quite like the number e as well, but not pressingly.

I know I can create a sheet summary item that equals 3.1415926535 and just reference pi# in formulae, but that's a value that could potentially be changed and I'd rather not have a clumsy sheet admin accidentally bork 40 dashboard-level area calculations and not notice it.

Really I just want to know if there's some version or substitute for a PI() function.

It'd be pretty bad if there wasn't one. Just saying.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!