-
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…
-
Report Card View: Doesn't exclude columns that are filtered out of the report
When using this, I expected the values in my status column drop down to be excluded from the grouping on the top sections. The current functionality gives false data impressions. For example, if I exclude On Hold projects the grouping says: On-Hold (0) which is inaccurate.
-
Report for a report contents & filtering parameters
I am making multiple reports from one sheet. Each report has slightly different columns and filtering parameters. It would be nice to run an audit report for the reports which shows 1) Columns List, 2) Filtering Parameters 3) Grouping and Summary Information.
-
Issues with TODAY() and daily reporting
Hi there. In part of my duties, I run a report that shows activities entered on a form from yesterday. We do achieve "yesterday" by using the following formula: =IF(DATEONLY(Created@row) = DATEONLY(TODAY()) - 1, "Yesterday", "Not Yesterday") In using this formula we have noticed some alarming discrepancies. Reports with…
