Is there any way to enter a Formula into a Report Cell?

Jake Gustafson

I have a sheet that has some weekly inputs. I've created a simplified Report View to only pull in the applicable columns from the most recent weeks/rows of data for the SME to populate. Recently, we had some data in our source information get split into two parts that our Smartsheet still only needs to report on as a single entity. The hope was that we could enter a simple formula into the relevant cell in the Report and the value would calculate. However, we are not seeing that result occur. Is it truly not possible to enter something as simple as =10+5 into a cell in a Report? I was able to go to the sheet directly and put in the formula and all is well. If that is what is required, then we'll need to go that route or create separate columns and have them each populated to sum up in the main column for reporting.

Andrée Starå

Hi @Jake Gustafson

I hope you're well and safe!

Unfortunately, you're correct, it's not possible now to add formulas to a Report, but it's an excellent idea!

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

I hope that helps!

Have a fantastic week & Happy New Year!

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 @Jake Gustafson

I hope you're well and safe!

Unfortunately, you're correct, it's not possible now to add formulas to a Report, but it's an excellent idea!

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

I hope that helps!

Have a fantastic week & Happy New Year!

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!

Jake Gustafson

Thanks @Andrée Starå.

Product Feedback/Idea submitted: Add the ability to enter simple formulas into cells in a Report View — Smartsheet Community

• Well ✅
• Safe ✅
• Fantastic Week 📉
• Happy New Year ✅

Andrée Starå

@Jake Gustafson

Excellent! Haha! 🤣

You're more than welcome!