-
Automate SharePoint Permissions to Dashboard Access / Sharing
This might be far reaching, but I was wondering if anyone has ever attempted or if there is even functionality to create a flow in Power Automate that shares a dashboard/workspace based on an an employee's email that was added to a permission group in an internal SharePoint site?
-
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…
-
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?…
-
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…
-
Is it possible to share a Smartsheet Dashboard to free collaborators with just a URL link?
Hello, I'm really hoping someone can answer my question! I am trying to create a dashboard that can be accessed by non-Smartsheet users with just a link. The only option I see right now is that if you do use a link, that person must already be "shared" onto the workspace. I am trying to find a workaround so I do not have…