Trying to run a simple report that shows all task in a project plan grouped by assignee with the total number of tasks assigned. Sounds simple but my Action Step leader (Assignee - Contact) column nor my Team (Multi select - Contact) column display as options for grouping or summary in reports. Thoughts?
Trying to get the average of [Page Views] for a given month [Last Activity]. Averaging the Total Page Views for the month of September The following returns invalid data type... =AVG(COLLECT([Total Views]4:[Total Views]55, [Last Activity]4:[Last Activity]55, =MONTH(9))) My assumption is that the test for the given month is…
I am looking for a method to query/report on activity log data without exporting to excel and then importing back I into smartsheet. For example: I need to expose via a Dashboard the number of times specific Dashboards and Sheets are being accessed. Currently activity logs are exported to excel; a pivot table is created to…