Is it possible to parse out a contact field with multiple contacts into a report or new sheet listing each contact on its own row? If that is not possible, can you do the reverse? I hope this makes se…
We have a main sheet to track trainings (which staff use a form to add their trainings to), and each staff member has their own report they can access from a shared workspace that pulls from the main …
So I have a column I am trying to get a count of by year for a Metric dashboard. I am using the following formula: =countif([Completion Date]:[Completion Date], ="2023"). This formula is not working a…
I would like to be able to set the time period shown in a published calendar view of a report. At present, it defaults to one month, and can be changed in the dashboard, but at that level, many detail…
Hi All, I am looking for a solution to a problem, I am trying to pull together a chart for a dashboard, displaying the number of overdue documents under review we have - the sheet is set up as below, …
I think with the extreme power of reporting on smartsheets and being able to get all the data you want in one place from multiple sheets, you should be able to link the report to create a graph rather…
When the selected report view includes days (e.g. Time & Fees>Days, or Time & Fees>Amounts & Days), it seems logical to expect that the underlying data includes at least 1 column for days. Unfortunate…
Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able t…
I need assistance with creating an automated report for each course in my spreadsheet. The spreadsheet contains information about courses and learners. Instead of manually creating reports for over 10…
This is a game changer for us, and we are sitting idle. We are examining other software that allows this functionality. This is critical for adapting to our changing business environments. This seems …