-
Lock the columns for everyone other than Smartsheet admins.
I want to lock the smartsheet columns for everyone to avoid the shuffling the column every now and then. And users who have access to the sheet, they can only edit the details but should not be able to shuffle the columns. Is it possible to achieve?
-
Automation for conflicting events on same dates
Is there conditional formatting function available to trigger a notification in smartsheet when a date is booked for two of the same items? For example; in a scheduling sheet, when the same equipment is booked on the same date?
-
Branching Logic for Approval Requests
I'm sure most of us have encountered a conditional approval at some point. Where we need to change something and then it's approved, or if they have comments but the approval is still pending and will need to be resubmitted, etc. Currently the approvals automation only captures values in binary form, yes/no, 1 or 0, option…
-
Weekly update request for newly approved rows
Hello, I'm trying to set up a workflow that will send an update request once a week for all the rows in which the status has changed to "Approved" during the week prior to the request notification. The update request should not include rows that have the status "Approved" if the status field for those rows was not changed…
-
Automatically Send a Copy of Response when Requesting an Update
When I am requesting an update using the Request an Update automation, is there a way to have the "Send me a copy of my response" box automatically checked? It appears this box only shows up with the particular automation
-
Import Excel Workbook as Workspace or Folder
Currently, the import function only allows importing one sheet at a time. An easy solution to accommodate workbooks with multiple sheets is to allow them to be imported as a new workspaces or folders, with 1:1 sheets.
-
What if an approval is conditional?
The "Request an Approval" automation is so black and white, it's either approved or it's not. Our executives' approval is, more often than not, conditional. It's hardly ever a black-or-white answer. What is the most efficient way to record the approval response? Option 1 (current): Request an Approval. If denied, send an…
-
Requesting Attachments via Update Requests Without Exposing Other Attachments
Hello, I'm interested in being able to send an update request to non-Smartsheet users outside of my organization asking for a document to be uploaded. My dilemma is that the update request exposes attachments already attached to the row. Is there a way to configure it so that doesn't happen? If that's not possible perhaps…
-
Timed Access
Hi, I want to ask if it is possible to create a workflow temporary grant/share access to Smartsheet items (Workspace, Sheets, Reports, or/and Dashboard)? My organization has a quite a number of people that temporarily need access to specific Smartsheet items and it's a bit of hassle keeping track of users so as to take…
-
Supporting app.powerbigov.us URLs on web content
Hi, I have been getting error messages when trying to publish a Power BI dashboard in Smartsheet dashboard. The current Power BI dashboard I have there is out data and I created new connections to enable users see up-to-date info but I can't edit it. I got in touch with support and was told Smartsheet don't support…