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
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 203 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives