Best Of
Re: Resource Management - Dynamic Report workaround
Yes, you're right—Smartsheet Control Center currently enforces a
The hard limit is 50 dynamic scope reports (DSRs) per blueprint, which can be quite restrictive for organizations that are managing large portfolios.
- RM is not a full replacement for dynamic reports. It’s best used for resourcing and capacity planning, not detailed project tracking or custom reporting.
Other Workarounds to Consider
- Rollup Sheets + Dashboards:
- Use summary rollup sheets to aggregate key data across projects.
- Display filtered views in dashboards instead of separate reports.
- Segmented Blueprints:
- Split your blueprint into smaller ones by department or region to get additional DSR allocations.
- Portfolio WorkApps:
- If you're using Portfolio WorkApps, you can create custom roles and pages that simulate report views without using DSRs.
Naeem Ejaz
Dynamic view, request editable option in table or Sheet view permission by rows
Hi, I'm looking for a way to restrict the view of a sheet so that each user only sees the rows where they are assigned. I know this can be done using Dynamic View, but I want users to be able to update multiple rows directly in the sheet, without having to open each row individually in a form.
I also understand that I can create reports to that respective user and share the report, but the main sheet I am using is updated automatically via excel and we don't know when a new user will be added, so making report for all user is not a feasible option.
Here's the situation:
- I have a sheet with columns for Resource Manager, their Assignees, and Assignment Hours for next week.
- I want to send this sheet to each Resource Manager so they can fill in the hours for their own team members.
- Each Resource Manager should only see and edit the rows assigned to them, directly in the sheet —not through individual forms.
Is there a way to filter or restrict the view in a report based on the current user, so they only see their own rows?
Shashank
Re: Dynamic Filter on Dashboards
In reviewing some of my requests, I am surprised that there is so little engagement on this request as it comes up so often in conversation when building dashboards for clients. When it comes to data visualization and the use of dashboards, so many people ask for the ability to use Slicers and dropdowns to view information that is on the dashboard. Especially when it comes to monthly progress reports, financial performance or even just comparing updates between months
I wish there was a way for us to add more tags to a post
#DataVisualisation #Slicer #DatePicker #DataFilter #Dashboards #Reporting
MarceHolzhauzen
Re: June Question of the Month - Join the conversation and receive a badge
Is there any other community than this Smartsheet Community? Do you even Community? This Community is the only one I've ever found myself participate in. In other communities I'm just a lurker.
Ray Lindstrom
Re: Third option for Approval Workflows
Please add an additional 'button' to the approval workflow. Many times decisions are more than Yes or No / Approve or Deny.
In our position reclassification process we have situations which are not that simple - and would benefit from multiple options.
Example - one of our teams currently has an option of "Acknowledged" rather than approved or denied. Other times, the approver may want to hold off on making a decision and "Further Discussion" is needed.
From a quick glance at the Community posts and questions on this topic - it looks like many smartsheet users could greatly benefit from this type of feature.
Crabe
Re: June Question of the Month - Join the conversation and receive a badge
The Smartsheet Community is by far the best community group I have been apart of. I can always find what I need here and the community members are more than generous with sharing information and helping me work through solutions. I try to return the favor by answering questions on the forum whenever I can.
Isis Taylor
Re: Bring Back the Outlook Add-In - Please upvote this!
I would to manage my work emails with smartsheet and I installed the outlook add-in. once I create a row from an email, it would be great to be able to link back to the email from the sheet in case i need to find the email rather that searching for it.
Duraid
Re: Bring Back the Outlook Add-In - Please upvote this!
YES, bring it back @smartsheet because it's very useful to save important emails for future audits.
Naeem Ejaz
Re: Deactivate all automation on a sheet
I'm a power user that builds workspace solutions for others. That means, when I build templates, I need to build them with hundreds of automations scattered across many sheets, for each project.
Automations cause a large amount of issues when importing data into a template initially, since oftentimes, the automation is designed to trigger each time data changes, which leads to hundreds or thousands of notifications each time a new template is activated.
It would be amazing to have a pause/toggle for automations that activates all of them at once; additionally a "suppress notifications" button for a particular workspace, so that certain projects can be muted rather than having to change the automation itself to stop email notifications.
jdunn