Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hi. Is there a way to automatically revoke sheet sharing access after a certain number of days (e.g. after 60 days)? We''d like to give a third party access to our file but only within a limited number of days but we want it automatically.
Hi John,
There currently isn't a way to set temporary permissions on a sheet such that they become revoked after a certain amount of time. When you have a moment, please submit an enhancement request using the Product Enhancement Request form under Quick links on the right of the community site.
To make the share/revoke process easy is to use groups and add your items to a workspace. If you create a group for your temporarily collaborators, it's easy to add the group to a workspace (even if you're only sharing one sheet), then you can revoke the entire group's access when needed. More info on using groups is available in the help center: https://help.smartsheet.com/articles/1554165-managing-groups-team-business-enterprise-
More info on workspaces here: https://help.smartsheet.com/articles/522067-workspace-sharing
You might even consider building a reminder on your sheet to remind you that you need to revoke access on a certain date! More on reminders here: https://help.smartsheet.com/articles/542913-using-reminders
I have the following column set up as a primary key for a datamesh. The intention is to copy each row over to a reporting sheet 1 time each month. This formula has not changed, and the records within the "BCA #" have not changed - yet I see to inserts into my reporting sheet from a smartsheet automation with differing…
Hi, We are a developer and building a custom web platform for one of our client who is using smartsheet. Our platform needs to get data from smartsheet and need to show the data in our custom UI. Could anyone recommend the APIs we should be using for this?
This solution updates a column formula across multiple sheets in a workspace. The script finds all sheets with a certain string in the name, finds a certain column by name on those sheets, and then updates all column formulas to a new column formula. At the time of posting, Control Center Global Updates did not allow me to…
