Still learning reports. If I create a rollup report, can viewers/users of that report edit it and have it update the underlying sheet?
Yes, they can if they have the right access.
Andrée Starå - Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
By ' the right access', Andrée means the user must have access to the underlying sheets.
They need to be at least a Viewer to see the data and Editor to change the data ON EACH SHEET.
If a Report rolls up 5 Sheets and the user has only access to 2 of them, then their Report will look different than a user that has access to all of them.
Are you able to edit a sheet summary report and have it modify the sheet summary that it is referencing? if so what do you need to do to make this work correctly?
Hi @Phil Cooper
I hope you're well and safe!
Yes. If you right-click on the row and select the Row Action option, and then Edit, you can change the values that aren't looked at or a formula.
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Very Helpful! Thank you. Have a great weekend yourself.
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Hi @Andrée Starå
Can someone, as a viewer of the source sheet, edit the report if they are the editor to the report?
Hi @Linh Nguyen
Unfortunately, it's not possible now because they need to have at least editor rights to the sheet, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
There might be a possible workaround.
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])
What Smartsheet plan do you have?
Be safe and have a fantastic week!
When a Report is shared, who can edit the Columns selections of the report?
The owner? Admin? Editor w/ share? Editor w/o share?
Hi @[email protected]
Have a look at this excellent help article for all the details.
Did that work/help?
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
BTW: I never add an email that someone had replied to my question above. Not even in my Spam...
A clarification should be made to the Report section:
A Report located in Workspace A can be made from a sheet host into another Workspace B we wish not to share. This Report will look empty to anyone only member to Workspace A.
A Report made for A from B can be useful to spin collaboration from my organization B and involving external organization A. Imagine this scheme could be also spread out by creating Report to organization C, D, E, etc from the sheet in B, etc. Author's name of modifications made by A, C, D, etc wouldn't be disclosed for each other, of course, but my organization B would.
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
Hello everyone, I'm wanting to run a workflow once every three months. If I set the trigger to be the first Monday of the month, every three moths, and starting today, will it trigger in three months' time on the first Monday? Or will it trigger next month's Monday (assuming this month's first Monday has already passed,…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.