Adding the number pi (π)

Nik Fuentes

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.

Andrée Starå

Hi @Nik Fuentes

I hope you're well and safe!

Great idea! That would be a great addition to Smartsheet features.

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• You could add the PI to a sheet and use cross-sheet formulas to reference it but not share it to keep it "secure".

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Nik Fuentes

I hope you're well and safe!

Great idea! That would be a great addition to Smartsheet features.

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• You could add the PI to a sheet and use cross-sheet formulas to reference it but not share it to keep it "secure".

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!