-
Contact Field Listing Multiple Contacts to Feed Individual Rows in a Report
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 sense.
-
Help need on reports
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 sheet to show only their trainings. The report has multiple filters/summaries. One staff persons report is coming up blank…
-
Creating a count for a Column
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 and I am not the best with them. Can someone help me figure this our?
-
Select the time period in a published calendar view of a report
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 details contained in each day's content is lost, and viewers may not know how to change their view. Thanks.
-
Count if date is in the past
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, and I have set up a 'metric sheet' however I am not sure this is the best solution. I have been using this =COUNTIFS({Master…
-
Use Reports to create graphs on Dashboards
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 just embedding the report into your dashboard. You can do both the report embedded but create a graph with the data as well.
-
Resource Management: Days column in Underlying Data
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. Unfortunately this is not the case; currently, the underlying data has 4 different columns for hours (Scheduled, Incurred, Difference…
-
how do I add a calendar view in a Dashboard?
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 to see it. I don't want them to have any any interaction, just see it as a reference. Is this possible? Thank you. Jef
-
Pulling a list of users who are taking a course
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 100 courses, I want to establish a link from each course entry that leads to a report or filtered spreadsheet listing the…
-
When will printing grouped reports be allowed?
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 basic. I know it's not. Are there any updates? Thank you