Convert Report Filter to Sheet Summary Formula

I have a number of reports with sophisticated filters that use an important master sheet as the source. I'd like to have the ability to create a formula from a report that I can paste into the master sheet's Sheet Summary section in a COUNTIF or SUMIF format. This function could be in the File menu under Save Filter As... and then select a SUMIF/SUMIFS or COUNTIF/COUNTIFS selection. Copy the resulting formula to the clipboard that I can paste into a sheet summary field in the source file for the report. You might have to limit this function to reports that use only one sheet as their source.

Sign in to vote!

Find more posts tagged with

Sheets

Reports

Idea Submitted

Enhancement Request

Comments

Mike M Consulting

Agreed. I would be nice if one could easily capture the underlying formulas from the report filters. I often have difficulty reconciling the # of items on a report with complex filters and the formula needed for my metric sheet to display the # from the report. (double/tripple work!)

Quick Links

Trending ideas

Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
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…