-
How to create 2-way sharing across sheets?
Hi, I am trying to make certain cells accessible for 2 way sharing. Is there a function like cell-linking that is available 2-ways? There is some financial data but mostly personnel/task and resources. Thank you, Esperanza
-
How Do I Remove Myself from Shared Sheets?
I have sheets shared with me that I no longer need to use and clutter up my "Shared" folder. How can I remove myself from them? All I've been able to find is information on removing people if you're the sheet owner, not if it's been shared with you.
-
Collaborator Name not Recognised When Trying to Apply a Filter in Activity Log
Hi, when looking at the activity log for one of my sheets I can see the names of the collaborators the sheet has been shared to. However, when I try to filter on one of the collaborators I'm met with the error message "Unknown User Entered". It doesn't matter if I use their christian name, christian name & surname, or full…
-
How to ensure data privacy?
Hi I want some of my users to be able to submit data using forms. But in order to be able to fill out a form, the users must have shared access to the sheet that contains the input form in question. With sheet sharing enabled, the users can easily see other users' data as well, which I want to keep confidential! Is there…
-
Can I add a specific row to an email from a workflow?
I have a smartsheet and there I will let people know when certain tasks have been executed. I have already created the workflow for that. My issue is when sending the email; can I add one row only on the email to notify that a certain task has been executed, so when I change one cell from "In Progress" to "Executed" a…
-
How can I get a list of collaborators with editor access?
Hello, I want to send an update reminder to people who have access to a sheet but only to those with editor access. There is a workflow to send reminders to "everyone shared to this sheet" but I only want to send it to those that will be able to edit (exclude viewers). Is there a way to get the list of editors shared to…
-
Can I get a notification when a new collaborator has been added to a sheet?
Hello, I have multiple sheets and dashboards created for different departments. We are allowing editors the ability to add collaborators to their sheets. I need to track who has been added as a new collaborator across all the multiple sheets so I can add these users in their specific groups (which grant them access to view…
-
Using a nested HAS formula within a COUNTM?
Hi there! For the life of me I can't figure out this formula! So here is the scenario. I have a grid with a dropdown multi-select column type with different organizational shared service options (e.g. Knowledge Sharing, Project Management, IT, Applied Learning). On a separate grid, I am trying to identify the number of…
-
View our recent webinar on collaboration and best practices!
Drive collaboration and transparency across your teams and organization, allowing everyone to work together to achieve more. View our recent Collaboration Best Practices Webinar where we shared how Smartsheet streamlines collaboration through: Sharing sheets and workspaces Intaking requests with forms Automating updates…
-
How can I delegate my smartsheet actions to others when I'm on vacation?
I am going on vacation and realized that my smartsheets need someone to manage them while I'm away. The only way I was this was to manually update every automation that includes me and add my vacation backup. It would be great if there was a way to set my profile to away and delegate someone else to act on my behalf. Is…
