-
IS THERE A WAY TO GROUP PER WEEK?
I am trying to group per week on a report so like it would say " week of mm/dd/yy - mm/dd/yy" or just "mm/dd/yy = mm/dd/yy"
-
Reports - Need an easier way to view all source sheet from the selection window.
Hello! We utilize a report that has 100+ source sheets. We've discovered a few sheets are missing and I need to cross reference a list of all the sheets that should be on the report with what is already on the report. Is there an easier way to do this besides scrolling through the list of 100+ sheets or having to type the…
-
Report information is not displaying on dashboard all of a sudden
I have built a dashboard that houses a number of reports, displaying where production is at which stages and the number of items being built. It recently stopped populating the report data and appear on the dashboard. When I click on the reports it brings me to them and the data is there and operational. I have attached…
-
Getting Smartsheet to Take a Snapshot of a Daily Report in Outlook
Hi Everyone! Every morning, I receive an automated email in Outlook with a report that includes different tables. I am creating a Smartsheet dashboard and was wondering if Smartsheet has the capability to take a snapshot (a physical image) of that report each morning and have it appear in my dashboard. Any ideas are…
-
Authorization List
Hello Team, Is there way I can generate the list of users, who I have granted access or as an administrator can I generate a report of a particular Sheet, Workspace or Work App. I am looking for all these 3 categories. We are grating access for multiple users from 2 differnet domain with differnet access level. I would…
-
Register for an upcoming Smartsheet Reporting Webinar!
Are you ready to create real-time summaries of your projects and track their outcomes, effortlessly? Attend one of our upcoming Smartsheet Reporting webinars to learn everything you need to hit the ground running. Register here! What to expect: A thorough overview of Smartsheet reports. Real-time answers to your questions…
-
Report Dynamics within Control Center Blueprint
Hello, I'm working on my first control center blueprint and am having two issues around reports within the blueprint. As background, I have Data Shuttle deposit all the accounting results across several project IDs in a central sheet within the control center Admin folder. Each project blueprint has an income statement…
-
Summarized morning checklists?
My program has three morning checklists that are completed on a daily basis to ensure systems are working properly. I currently have a sheet built for each checklist with a form feeding each one. I want a report to be triggered when all three checklists are submitted and for that to be sent to a specific person. Each sheet…
-
Automations not kicking off when cell updated from a report
I have projects with automations that update a target cell after a source cell has been updated. Specifically: if % Complete = 100%, set Status to Complete. The automations work when I'm updating from within the project sheet. But when I update % Complete from my master report that aggregates all my projects, then I notice…
-
Creating a Portfolio View for Project Outcomes
Hello- I am trying to create an executive view for our portfolio that highlights the Project owner, status, summary, and then active issues, risks and changes. Mock up: I have created summary fields within the project plan, QRAIDD log and change log in order to get the count like my mock up above and am creating a summary…