Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Report Filtering
Hi
Can we create and use "on the fly" filters in smartsheet reports (just as we do in Google Data Studio).
For example, the current view of my report is showing me all the data of this year; but while viewing this report I might wish to view only last 30-day data, which was posted by a specific person. So can we accomplish it instanlty by applying some filters?
thanks
Nasir
Answers
-
The only way to filter reports is to adjust the report builder.
One option would be to create a second sheet that has a form linked to it. This form can be used to select the options you want to filter on. Then you would use helper columns in the source sheet to look at the most recent form entry and flag the rows accordingly. The report would then be built to only show flagged rows.
You can have the form take you to a specific URL after submission and use the report's URL, or you can display them both side by side on a dashboard.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hello Team, May be this is intentional, but want to double check. In a sheet, when i open the conversations window, I am able to see tabs for "Row", "Sheet" "All" and "Unread". On the contrary, in a r…
- Hi everyone, I have experience using Smartsheet Core Product and I'm Core Product Certified , but I am new to Smartsheet Control Center (SCC). I am currently preparing for the Smartsheet Aligned Solut…
- Can I and how do I set conditional formatting for a Finish Date font to be red if the date is in the past and % Complete is not 100. Is there a way to set multiple conditions for Conditional formattin…
