Limit View to a user for one filter Only
Hi,
I used a sheet to create a global timesheet for one department. Then I created one filter by employee so they can see only the row who applied to them. Is there a way to limit view by user? By example, I want that Marc see only the view with filter ''Marc'' and cannot remove this filter so he cannot see other people time.
Thanks
Best Answer
-
Because they need to be able to edit, there are two options.
- Report, but then they would need to be shared with the sheet, and they could potentially see the other Employee's Hours.
- The Premium Add-On, Dynamic View.
More info:
Would any of those options work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi Julie,
Does the user only need to view the information or edit it as well?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Edit only cells as it's a timesheet. He have to choose project number in one cell and add hours in the other one. See picture below
-
Hi @Andrée Starå ,
You have an answer for me? :) Thanks!
-
Because they need to be able to edit, there are two options.
- Report, but then they would need to be shared with the sheet, and they could potentially see the other Employee's Hours.
- The Premium Add-On, Dynamic View.
More info:
Would any of those options work?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @Andrée Starå ,
And if the person doesn't need to edit, is it possible to limit view to only one or few filter in a sheet?
-
Unfortunately, it's not possible at the moment to limit the view, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could Share specific filters, but they can still show everything in the sheet.
Another option could be to create multiple reports instead.
Would any of those options work/help?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives