-
search for reports containing a specific column name
I would like to search for reports that are being used that contain a specific column name, so that I can include a new one next to it. So far I can only search for reports by name, not reports containing a specific column name. Is this possible? Thanks
-
Summarizing a column in a report is only giving me a sum of half the data
I built a report from two separate sheets using a row report. I intend to add onto this weekly. When I try to total the sum of one column it's only giving me the value of half of the data. It's only giving me the total amount from the bottom half. Is there another way to group this information? In both sheets I've named…
-
How to properly use a scatter plot graph?
Hello all, I am in need of representing data through a scatter plot. Currently I have 2 main columns each numeric and the respective project name. My two numeric columns include data for project urgency (a given value from 1 to 5) and a total score for the project. I want to be able to have this data represented through…
-
Ability to modify a re-occurring send list when sending a report from Smartsheet
Currently there is no way to edit an send list (email addresses) when sending out a re-occurring of a report. I am having to set up a new re-occurring send list when someone new needs to have a copy of the report. Also, we have users that are no longer w/ the company and they still remain on the send list.
-
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:…