-
Allowing Multiple Smartsheets to be published to One Google Calendar
I would love to be able to publish several of my smartsheets to one google calendar so everything is in one place. Please let me know when this feature maybe added! Thanks
-
Automated Email 2 days after a date if no attachment
Hi There, I have a fair bit of automation setup in my workspace for all the relevant rollout / install sheets to do multiple things including: Send reminders 1 and 3 days prior to ensure the store/retailer is aware and the space is clear Reminder on day of install at 5pm to ensure an attachment of the evidence of install…
-
Need to identify who responded in the survey
I have two sheets. Sheet A is the master list of the names while Sheet B is the list of the respondents of the survey form both containing the unique identifier code. I need to identify who has and has not yet responded to the Smartsheet form. Questions: Is there a way to automatically mark Sheet A when a person submits…
-
Automation Workflows - Alert Someone - Ability to see full distribution list
The Automation Workflow to alert someone when certain actions occur is a wonderful feature. It would be a great enhancement to have the email show everyone who receives the notification. A lot of times, the workflows are setup to alert multiple people, but the email comes through as showing only the recipient. Sometimes…
-
Why is this happening all of sudden?
Hi all, I have had an automation set up (and working fine for quite some time) that copies a row to another sheet and then moves that row to a different sheet (Archive) when "send to Archive" is checked. As stated, this workflow has been performing perfectly for several months. Nothing in the source or destination sheets…
-
Changing File Directory for downloaded attachments
Hi all, For context, I use a Form to manage incoming service requests and generate PDF Work Order attachments. I would like to change the file directory for downloaded attachments to a shared folder rather than 'Downloads' so my supplier has visibility of the work orders when they are assigned. I can't seem to find an…
-
How can automation change a cell value without the appropriate approval workflow trigger being met?
This one is a doozy and I feel like I must be missing something obvious, so bear with me: According to the activity log on my sheet, the status of three rows was updated to "04 Shareholder Review" by Smartsheet Automation this morning (6/8/23): The problem is that all three rows had already been fully approved and sitting…
-
Import Smartsheet rows into Miro Kanban board
Hello, is there an automation that will help with importing smartsheet rows into a specific Miro template? I would like to use the Miro kanban board since it actually has swimlanes and want to avoid manually dragging and dropping every single project task.
-
Smartsheet Automation to Remove a Single Value from Multi-Select Cell
I have multiple columns that denote tasks; Task 1, Task 2, Task 3, Task 4. Each of these tasks can have a cell value of; Completed, In Progress, and Not Started. I then have a multi-value dropdown column called Team that denotes what teams are necessary to complete a project. I have an automation in place to add the teams…
-
Automation Not Triggering
Looking for guidance on why this automation might not be firing. Could it be that I'm using a column formula to populate 0, 1, or 2 in Vendor Helper?