-
Changing ownership makes Chart Widgets turn to Missing Source
As the Smartsheet Admin, I create most of the Sheets, Reports, and Dashboards for the Executive team. When we transfer ownership of all Sheets, Reports, and Dashboards to the Executives, their Dashboard Chart Widgets all state "Source Missing". Smartsheet's Help Desk provided this response: "... you may need to transfer…
-
How to create reports according to the Month
Hello Everyone, I hope all are doing great I wanted to generate a report which is getting data from multiple sheets and its primary column is Months so according to the months, I am creating the report/chart. Now, the problem is I want to create a graph for this which shows the current month and then the next 11 months.…
-
Broken Workflow Report
Is there a way to run a report (or an easy search) which lists which projects (over 300 of them) have a broken workflow, rather than checking each one individually to see if the automations are broken?
-
Aging report
Has anyone built an aging report within Smartsheet? I am looking to track the following three items time between when a row is submitted and the team is responding from the time a JIRA ticket is submitted and the status is changed to close Status column when it moves from client to closed
-
Clickable phone numbers in reports
I need to have phone numbers clickable so we can click a phone number from our phone rather than copy/pasting it. Is there a way to do this? I thought embedding some html code would be an option, but that's not working. It isn't a link when viewed in the report, through email after being sent, or on iPhone or Android.…
-
Parent Row in Report
I have a scheduling sheet that I use to keep track of each project manager's pre construction timelines. Each project manager has a sheet to keep track of multiple projects. I have created each project as a parent row with children rows with each task for the referenced project. I am trying to create a report that shows…
-
Reports and Dashboards break if column is renamed in a Sheet
Reports and dashboards break if the columns in the source sheet are renamed :-( It will be great if @smartsheet does not depend on the column names from the sheet when used in reports as it will then not break the reports and hence the widgets in the dashboards using those reports as source.
-
Blank Report
I shared a report with a customer. When the customer opens the report it is blank. It doesnt show any of the data? I tried sending a link to the report as well. Still nothing in the report. The customer setup a username and password. Im obviously missing something. Any ideas as to why the data doesnt show up in the report?…
-
How to restrict rows by contact
Hi all, I am traying to create a Disciplinary Actions report where the manager can only see the inforamtion he has assigned. I have some others managers, but In the report, I want he only sees the rows that have his name.
-
View Predecessors in Reports
Is it possible to view the Predecessors in a Report? When I create a Report from a Project Schedule, it does not show the Predecessors dependant on that task, it only shows the number of predecessors. I eventually created a duplicate column and put in a formula to copy the value of the Predecessor column and use that new…