-
Report not updating after source sheet is edited and saved
Hi, I am trying to update a report but whenever the source sheet is updated and saved, those updates do not filter into the report. I have tried waiting to see if it just takes some time to update, refreshing both sheet and report, closing out of and reopening both sheet and report, but nothing seems to work. Additionally,…
-
Running a report with multiple drop-downs
Hi. I am running a QI report where we are looking at any kudos for our agents. We want to recognize our top performers, and we have a sheet where we collect that data for specific agents and incidents. On most incidents there will be 2 or more agents receiving those kudos, so we created a multiple select drop-down to enter…
-
Report in Dashboard - how to disable the "open report" link?
Hi all, since some time there is an open "open report" link under each report in the dashboard. But the user should not be able to open the report, how can I disable this? Thank you
-
Status Circle Automation
Hi, I am using status circles for a high level status report. Is it possible to automate the 'Overall' Status Circle based on the colors in the other measures (budget, timeline, scope, KPIs, value). For example, if 4-5 of the metrics are green, Overall is green. If 3/5 are green, Overall is Yellow. If 1-2 are green,…
-
Report on all sheets I am part of as Assigned To
Many of our team members will be allocated to many different sheets. 1. Is there a feature how to make a report showing all sheets I am assigned to?, and as a continuation a report showing specific tasks in those projects, for example Gate Review, or Offer Submission? Those tasks are not necessarily assigned to that…
-
Current User on Report
Hello, I tried to search for this but didn't find anything that could help so I was hoping somewhere here can help me. I have a report that looks at data and returns a date, shift, current user, and then it groups the results by date. The problem that I having is that when I add that to a dashboard so that people can see…
-
How to show target milestone in addition to actual start finish columns?
The sheet has the columns: Target, Start, Finish, Duration, Predecessor Is it possible to show the TARGET date on the gannt view (preferably as a milestone) in additional to the actual start and finish bar? I don't want to create extra rows to show TARGET as 0d. Please tell me we have this feature :)
-
Can Formulas Reference Reports?
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person. When I go to do that and the formula asks me to reference a sheet, I am only…
-
Need report to prompt for string search
Hi, I am creating a sheet tracking City's address modifications. There should be a report where users can see if there already were rows with similar address. Hope there is a way to enter a search string for report to show rows whose address column has such string. Something like {{Enter search string}}...
-
Adding Partial reports to Dashboard not working.
I am trying to add some portions of a report to a dashboard to build a chart but when I go to add data, it will only allow me to choose the entire report. I havent used smartsheet in a few months but I could of sworn that I was able to pick data points within the report to chart. Is this normal? I was thinking maybe its a…