Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Is there any way to create a report that checks all workspaces? For example I want to make a report that shows a project manager everything that is assigned to her. If I make the report today I need to manually select 8 workspaces. If I update the report it will probably grow to 16 workspaces. If I make reports for 20 project managers do i need to manually update the "Where" criteria every month? I'd like to avoid this if possible. I'm really just looking for a better way to let project managers manage their workload. This is step one. Step two is a report where the project manager can look at any assignement for others where they are the active project manager. Thanks for your suggestions!
Hi Mike,
Unfortunately, it's not possible at the moment to include all workspaces and keep them updated with new ones, but it's a great idea!
Please submit an Enhancement Request when you have a moment.
The easiest way that i've found is to have a naming convention so that it's possible to search and see all workspaces and then select all there.
If I understand you correctly report for the project manager to see all assignments for others is possible today.
I hope this helps you!
Have a fantastic weekend & Happy Holidays!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hey Smart Community, Currently I am working in a project which large registration form with nearly 200 questions with 5 category groups. Q 1 to Q15 is common to all Category Q16 to 49 exclusively for Group 1 Q50 to 79 exclusively for Group 2 Q80 to Q115 exclusively for Group 3 Q116 to Q165 exclusively for Group 4 Q166 to…
Hi everyone, In our project plans, sheet admins are responsible for setting the baseline once the project schedule is finalized. However, this step is occasionally missed, which impacts our schedule variance and reporting. I'm looking for best practices to remind admins to set the baseline via automation Also, is it…
I have a form that others in our organization use to submit projects to my department. How it should work: 1) the form when complete populates a row in the Spreadsheet. 2) automation maps certain fields in the form to a PDF. 3) The new row triggers an email to our department with the PDF attached. This used to work…
