Calculation Formulas on Reports

Tiffany Fuller

Our company uses Smartsheet a little differently than most but I am finding it would be very helpful if I could add formula calculations directly to the reports I pull. Currently I have to add the formulas to the sheets themselves, hide those columns and continue dragging formulas down as we add rows. Hundreds of sheets... this is very time consuming. It would be great if when I run a report for, let's say, 3 of those projects, I could add the formula that is specific to that price point on those projects. 

L_123

Our solution was to use a category column already existing in the worksheet and make the bottom columns listed as z.math and post the information off to the side and hide it. This allows us to sort and filter, and we don't have to update the columns with the formulas ever. It's not optimal as you can't see the information on the worksheet, but it works well enough.

Tiffany Patton

I saw that this was requested back in 2015. There really is still no movement? As much as I love Smartsheet for tracking tasks, I am continually reminded of the shortcomings.

FactionPMO

yes, as a team of 2 supporting our entire organization I need a way to quickly generate metrics/kpi's and I'd really like to run a report to consolidate information and then calculate with formulas in the report. 

Andrée Starå

Hi everyone,

Please submit an Enhancement Request when you have a moment to have your vote added

A New Way to Submit Your Feature Requests

To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.

Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requests

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD