-
Formula to calculate day from a series of dates and times
Hi All, This might be a long shot but is there a formula to search and find a multiple entries of a job number then look for the date column and calculate the series of dates for start and finish time and also include the in and out times to create a Gantt chart? This is all data that will be entered into a separate…
-
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?
-
Ability to modify report filters on mobile devices
Please extend the capability to modify filters within a Report to mobile devices. This feature, presently accessible on desktop, should be available on mobile platforms too to enable on-the-go adjustment of parameters. The absence of this functionality currently compels Report creators to generate numerous reports in…
-
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?…
