-
Add new filters in Report
Hello, I would love to have in my reports the possibility to filter on "This year", "Next year", and "Last year", according to a date type column. Today we can just define an date interval for example "after 01/01/2023", "before "31/12/2023", and it has to be updated every year. I hope some of you will vote this…
-
Drop down on dashboard pull all matching rows
I am trying to build a dashboard that will allow someone to enter a Asset# and it will pull all rows from a sheet that match that Asset#. The Primary Column is a Inspection number that contains the asset# and date. There is a separate column that is the Asset#. It would be even better if it would show it from youngest to…
-
Filter Report Based on Cell
I have some reports in a template dashboard that I would like to filter based on the data within a cell. For example, I have a report to show a project's weekly update. I would like the template to look at the project name in the metadata to filter for that project's weekly update instead of having to manually update the…
-
Retrieve Date from a Report to a different Grid Sheet
Hello everyone I have a report view that reads from sheets A, B, C I want this report view to copy the data to grid sheet called D Is this possible? thanks a lot !!
-
can't see the data on report despite that there is data on the form, what is wrong?
Since days ago I can't see anymore the Data of my active project report, despite that the project intake sheet has the information. I try to create a new report, also try to filter again, to make a copy of intake sheet and create a new report, but nothing works Help
-
Report not pulling data
Hello, i created a report pulling in data from 8 different sheets. but, when i am adding new rows to the individual sheet, it is not visible in the report. Any idea why? Can this be because of the filters that i have applied?
-
Using COUNTIFS to find a partial text match in 1 cell + other conditions
Hi Smartsheet Community, I'm having trouble with a COUNTIFS formula and hoping you can help. I'm trying to count all rows that are assigned to a specific person. Because it's possible to have multiple assignees for a task on my sheet, I need to do a partial match for the assignee name. Here is the formula I've created:…
-
New! View your reports in card view.
Hi Community, We're happy to announce that you can use card view in not just your sheets, but also your reports. Card view gives you quick and actionable insight into the status of work across all your projects by visualizing tasks as cards that can be dragged and dropped across lanes. Now, with card view in reports, you…
-
How to identify the reports and dashboards to which an external contact has access?
To those in the know, I've been made aware a couple of dashboards and reports has been shared to an external contact over time. I'm trying to identify all the resources they have access too, so I can consolidate and streamline the reporting. Short of asking the external contact to do a screenshot of their personal…
-
Trying to get a report filter to show what I need - any ideas?
Hi there, I have a report that I am using to show all the Smartsheet rows that are about artificial intelligence. I have several filters set using the "contains" option. As you can see, one of the items is AI. Unfortunately, this pulls everything that has AI, such as the word "contain." When I put AI in quotation marks,…