How can a free user view a document via an automation?
We have documents attached to a sheet and have created automations to alert internal and external members when they are available to view and download. However, they are unable to see the documents attached to the sheet. They currently have Viewer access to that sheet--does that need to change? And is there a way to attach…
How to share a form after it is filled partially?
The form first needs to be filled partially and then shared to others to complete the rest of the form using the information previously submitted. The previous information filled shouldn't be made editable to the next user of the form. Is that possible? In the attachment, I want first four fields to be filled by me and the…
Hide comments and attachments on calendar embedded on dashboard
I am creating a customized dashboard for all of our stakeholders to view events and trade shows within their region. The main file is used by my team to plan all of these events and trade shows, so it has a lot of comments and attachments that I do not want to share with stakeholders. When I created a report to show the…
Send an e-mail when a box is checked?
Hello -- Very new user here. I have a general technology knowledge, however, I'm having a logistical brain fog at the moment. Could I use an IF THEN statement to send an e-mail notification when a Box is checked? paint drawing (don't have any other fancy program on my work laptop haha) for explanation. Thank you!!
Hi, I'm trying to reference a cell that contains a dollar amount based on a date range.
This is what I'm trying (unsuccessfully to accomplish) =IF([DATE SUBMITTED]@row >= DATE(2022, 12, 1), [DATE SUBMITTED]@row <= DATE(2022, 12, 28), "PO Amount Including Change Orders" Looking for the amount in "PO Amount Including Change Orders" to show up if the cell "Date Submitted" falls within the date span. Any ideas?…
Copy/Paste Permission Issue
I have a member of my team that attempted to copy/paste some information from a sheet where his permission level is "Editor - can share" to another sheet where his permission level is the exact same, but was told he could not. Full disclosure we have a workspace and that is his default permission level so anything added…
WorkApps - Domain Access
Hi All, I'm setting up a couple of WorkApps is there a way just like with Dynamic View where we have the ability to share access to a domain? Thanks Craig
Smartsheet's Dynamic View blocked in China
Hi, My team and I set up a process to request updates to our partners in mainland China using Dynamic View. Two weeks ago, we started to receive notifications from our partners that they can't create their Smartsheet accounts to access the Dynamic View, or even worst, those who were able to set up their account 1 or 2…
Locking cells in sheet
Hello, I am trying to determine if there is a way to lock the formulas I have placed in my sheet so that the users cannot override them to hard key in numbers. The formulas have been entered into all of the necessary cells but as it stands, users can simply clear them out to enter the amounts in their own way. We have…
Free User can't modify Sheet
Hi All, I have shared a sheet with an unlicensed use with the role as "Editor - Can Share", but it can only access to the sheet in Only View mode and it cannot edit. What i'm doing wrong? I have a Pro Plan. This is a test user with my personale email that i've invited without a license. With this user i can see the shared…