-
Report Filter - Can you filter one column against another or a summary field
In the report filter, can you compare the value in one column against a summary field or another column? For example, I am building a report that needs to pull data from a sheet for rows that were created in the previous month. This report will be going into a dashboard and will need to be updated every month. At this…
-
How to count total checked in report instead of just total number in report?
I am trying to use the report to summarize some data to ultimately put in a Dashboard. In the screenshot I am actually trying to count the total number of T4C completed which would be indicated by the check mark. Instead it is currently counting the total number in the report, checked or unchecked. I am using a report for…
-
Report not visible to person who has Editor/share access
Hi, I didn't want to give a person access to my sheet so, I said I would create a report for them with the information they would want to see from the sheet. I did so and shared it to them with Editor/share permissions, but when they access the report, they don't see any data. What could be the reason for this? They don't…
-
No Drop Down entry for the week
I am looking for a formula to indicate if there are no entries of an item in a drop down menu within a particular week of the year. Below is a brief rundown of what I have accomplished, and what I desire. I am looking to create a report or dashboard to reflect if an inspection on a particular device has been completed for…
-
Creation Date Report
Hi All, I'm looking to create a report that will allow me to source the creation date of all my sheets. I've tried googling but all reports lead me to last edit dates rather than the original sheet creation date. Any assistance would be greatly appreciated. Thanks, Evan.
-
Merged: Formatting within a Report
This discussion has been merged.
-
Notification and capability to create report for all broken links (Cell Link References)
When links are broken on sheets, we want to be notified and to be able to create report on all sheets in Workspace, so we can fix all broken cell links ASAP. Each team has different schedule sheets and we use cell link from one schedule to another and we depend on the dates on the schedule. Currently there is no…
-
Sum from Report
I know this has been asked but it's been a while so maybe there's been a change 😀. Is there a way to do any of the following? Use data shuttle or some sort of automation to export a report to a sheet in Smartsheet or to a Google Sheet? Use sum formula on a sheet from a workspace? (so that I can sum all project plans within…
-
Why are most of my months showing up "N/A" when I know there is data?
Why are my metrics showing N/A on mostly all of my months for Long Term Project TCC? Please see formula below Populates only one month:
-
Update Column Names in Report Filters
I searched for this feature request in the Community but didn't find another post to upvote. It's great that reports mostly no longer break when a column name is changed, but if you change the name of a column used in a report filter, that does still break. You won't even realize it unless you notice an issue with the rows…