-
Reports: Group By Label Display Issue
If I make my primary column an Employee ID and want to make that column smaller, it cuts off the name/label of the column I am grouping by in the report. Is this a product feature upgrade that needs to happen or a glitch? It is super inconvenient and makes my reports look very ugly when there is a ton of space left after a…
-
How to use COUNTIF on a Smartsheet Report
Hello - I have a report that manages all past due, in progress, and upcoming tasks sorted by team member. I am trying to use the COUNTIF formula on my Metric Sheet to count the number of past due tasks by team member in the report. My goal is to use my Metric Sheet to gather the number of past due tasks by team member and…
-
How to count total number of times a value appears in cells with multiple values.
I have been trying to find a formula to use that will let me count the total number of times a day appears in this column. I would like to ultimately put this info into a graph on the dashboard. Is there a way to do this? I have tried using the COUNTIF with CONTAIN and I haven't been able to figure it out while on a…
-
How can I click into a report in a dashboard and have it bring me to the sheet?
Is there a way to be able to click into a row in a report on a dashboard and it brings you back to that specific sheet? Not to the report, but the sheet that the row was created from? So far I can only find out how to go back to the report. Is there even a way to do that?
-
Report does not display new sheet names
New user here. I have looked through the help but cannot find my specific question and hope to find help here. I ran a report summarizing specific content from various sheets and filtered the results based on which sheets and content to display. I updated all underlying files to sort them in a way I want them which also…
-
Show parent OR task at same level as parent in report
My past due report was showing the naked tasks without context, so I wanted to add the parent. I added a helper column with '=(PARENT(Tasks@row)) and grouped the report by that column. That works for some of the items, however here's the issue, some level 3 items have sub-tasks and others don't, so some tasks are at level…
-
Why does a report show up blank on mobile device
Why does a report when accessed via a mobile device like the iphone show up blank unless the viewer selects the button #2 at the top. This can be very confusing for people not familiar with SS. Any way to force the button #2 to show by default? I assume if I embed on on a dashboard it would correct this but why do this…
-
Edit Reports Sent as an Attachment
Not exactly a new idea... But, something that would make my life easier. I have reports set up to send as an attachment to our client weekly. The distribution list occasionally changes. When this happens, I have to delete the schedule and start from scratch. The only thing I can edit is the schedule of when it is sent and…
-
Cross Reference Report - Workaround Ideas
Hi, I know that I cannot cross reference a report; I'm hoping someone might have an idea on a workaround. I have a report that gathers data from all sheets in a specific folder. The quantity of sheets varies around +/- 200. I want to get one summary field (to match on) and the sheet link from each sheet into another sheet.…
-
Cumulative record of live sheet summary reports
Hi everyone, I have a sheet summary set up on every project, which tracks a number of weekly KPIs - e.g total tasks that week, total completed that week etc. The sheet summaries feed into a larger sheet summary report which shows these KPIs, but only for this week. I'd like to capture the info in the sheet summary report…
