-
How can a contact field by aggregated to show a count?
I have a list of projects and each project has an individual as a contact. An individual could be listed for multiple projects. I'd like to chart to reflect how many projects each individual is responsible for. The trouble I'm encountering is that the report doesn't allow me to summarize on the contact list field and the…
-
Limit rows on a report
Sorry if this has been asked somewhere else.I am new to SmartSheet and have had a look in community but couldn't find an answer. I have a Kanban board setup in SmartSheet and have a few reports running that are displayed within a dashboard Currently I have a report that pulls all items and orders by a creation_date field…
-
Report Column Synonyms
When creating a report, would love to be able to apply a synonym to a column, similar to having the option to apply a label to a form field. This would offer great flexibility for report writers and consumers by providing the ability to support the custom terminology. For example, the 'Name' field in a Demand Management…
-
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?
-
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…