Add the ability to enter simple formulas into cells in a Report View

I've got a Report View that simplifies what columns & rows are displayed out of the full sheet so that a user can input data on a weekly basis. We recently are facing a scenario where we need to sum up multiple values into a single cell. Although the math isn't 'hard' it is more efficient to simply type in i.e., '=123+456' and let Smartsheet calculate and display '579'.

As a Smartsheet Report User, I want to be able to enter single formulas into cells, in order to perform quick calculations within the sheet.

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

Sign in to vote!

Find more posts tagged with

Formulas

Reports

Idea Submitted

Comments

Franklin

currently there is no way to update formula directly in report or add any new column. suggest to open those area in report just like update in raw database.

Katie461

It would be great to add a simple formula in a report. I have successfully meshed several sheets together to make them visually appealing with all necessary information, but I cannot SUM any columns/ cells (ex: cash Inflow/ Outflow) on the report itself. I realize I can create a rollup sheet and pull that in, but seems like unnecessary extra work & sheets that shouldn't be needed.

Sophie_Centurion

Please please please allow us to enter = 5+10 into a cell in report view. I see no reason why this should function the way it currently does by converting it into text.

Quick Links

Trending ideas

Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
WorkApp Analytics
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
Sheet Icon Color Consistency
The 'Sheet' icon appears purple in the left navigation but blue within the sheet, creating inconsistency. Aligning icon colors across the platform would improve clarity and simplify user training. Please standardize the icon color to enhance user experience and reduce confusion during onboarding.