-
Is it possible to set up a recurring update request that keeps sending until all cells are updated
Hello, I've set up a sustainability tracker for a team at my organisation and they are hoping to limit who access to it, whilst still wanting input from certain collaborators. My idea to achieve this would be using an automated workflow - namely an update request. I'm wondering if it is possible to set up the update…
-
How can I remove direct access to a Sheet, but still allow editing via Report?
TL:DR We are looking for a way to change/break the url to an existing Sheet (340+ columns) without breaking the connection to hundreds of Reports, thus preventing direct access to a Sheet people already have the secure link to, while still allowing view/edit access to the data via Reports. We've considered some options…
-
How do I share a Dynamic View
I must be missing something very obvious. I've created a Dynamic View of a schedule that is filtered based on a column that contains contacts. I assigned a contact, that didn't automatically alert the person assigned. In the sharing tab of DV I added their email. That didn't alert them. I read in several places in the…
-
Lock a row (preventing editing) while row is open
Hi there, we have a scheduling Smartsheet that we're having some troubles with. Users are booking appointments in the below view, but since the row isn't locked out while this is happening, we're ending up with double-booking because two users overlap using the row. We have multiple people in the sheet, so if two people…
-
Is there a way to limit what others can view in a shared sheet while still allowing them edit access
I'd like to be able to share a filtered view with clients that only shows tasks assigned to them. I've been able to set up a saved filter and default view, but clients are able to turn the filter off which then allows them access to ALL tasks. Is it possible to limit what they're able to view while still allowing them edit…
-
Best Practice: Enterprise Sharing with SysAdmin?
My organization has an EPMO and as we roll out Smartsheet, the question has come up that if someone creates a new workspace they don't have to share it with the SysAdmin. Has anyone developed some standard in their organization that 'requires SysAdmin sharing' even as a viewer only? If so, do you have any examples of the…
-
Unable to Insert Column
All, I am a licensed user on the business plan. My co-worker, also a licensed user on the same account, shared a sheet with me; he is the owner. I am a listed as "Editor - Can Share". I am unable to insert a column. In fact, I can't make a change to the sheet structure at all - can't rename a column, change the data type,…
-
Unable to share sheet to the owner of the sheet using share api.
On calling the following api, getting the "SUCCESS" message but sheet is not shared to the owner. Is there any way so that the sheet can also be shared with owner through an email?
-
Issue with Filters on Links
Hello, I have a large project sheet where I am trying to create multiple links on our SharePoint site. Each link should show a different filtered view of the Smartsheet grid. I thought this could be done by hitting the Share button, editing the Default View, and then copying the sheet link. The hyperlink changes so I…
-
Collaborators section
How can I get a list of all Collaborators in one Smartsheet? I just want to pull like a report or list without having to go to the Share Window option