Sign in to join the conversation:
I managed severals collaborators and for easier management
I want to create several task in one sheet that will be assigned to different collaborators and I want each collaborator to allow see only the affected tasks. It's possible?
There are many ways to do this. The way best for you will depend on the way you are sharing the Sheet, the Collaborators Permissions, and type of Smartsheet Account.
If all of the Assigned To users are on your account and they have editing rights to your sheet, then the best way would be to make a filter so that the "Assigned To" Column (which should be a Contact Column) is equal to the "Current User". Then you would make that your default view for sharing. (Keep in mind, if you're not Assigned To any of the tasks, you won't see anything while the sheet is filtered. This is based on the Smartsheet user logged in.) Please see attached photos.
If you'd like further instruction, I'm happy to help.
Hi Jessica,
Thank you for the answers, unfortunately I can't assign a task to a collaborator without him seeing the other tasks.
in your answer you say " "Assigned To" Column (which should be a Contact Column) is equal to the "Current User". But, if I use the equal Option I cannot have "Current User option". Please see attached photos.
Would you have another solution to assigned task to the collaborator where they can see only the tasks assigned to them?
Answer from Stephanie:
Hi Harouna,
It is not possible to share a user to a Sheet and have them see only their tasks. If you share the Sheet, everyone can see everything in that Sheet.
There are a couple alternatives though:
Cheers,
I'm sorry, I didn't mean "is equal to" it should be "is one of" then you can select Current user. Then when sharing the sheet, you'd make that the default filter.
Another option would be to build a report based the collaborators. This is very easy & real time.
Are you familiar with Reports? If not i can help walk you through creating one.
Nice to read you again.
I'm not familiar with Reports, yes you can show me.
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
