-
Send notification only once
Hello Community, I have a problem with notifications and so far no workaround. I have a sheet that pulls all the information from other sheets so no manual entries are done in that list. If there is a new date in one column (project end date) the sheet should send a notification. Since the notification automation works…
-
Starting from scratch.
Hello community! I am new to Smartsheet and I am trying to work on a my Hospitals volunteer databases to bringing the 3~4 different programs that we have running into Smartsheet. We have one for each of the following; volunteer onboarding/application tracking, annual learning, volunteer time and location tracking, and…
-
Automation Workflow Step Through Mode
Create a mode that allows administrator to step through an automation workflow. Feature should allow stepping through one step at a time and being able to go back to the sheet to see the result to that point. Also provide method to select a point in the work flow to stop the workflow at a specific point while in this mode.…
-
Automation Advanced Options
I was automating a sheet and "Please set the approval settings via 'Advanced Options' popped up before I could save it so I clicked into "Advanced Options", but even after editing them, it won't allow me to save it. I receive another pop up that says "Enter unique dropdown text values, and unique button text values" No…
-
What does "in the next 45 days" mean in an automated workflow condition?
Hello, I am trying to figure out an automated workflow where the trigger is everyday at 8am and the condition is where a [Date Column] is in the next 45 days. I have many rows in the sheet that each have unique dates and emails to contact when 45 days prior to that date is reached. My question is: does "in the next 45…
-
Status Rollup Automation Becoming Invalid
I wanted to automate status rollups for parent rows. Via the forums I found this writeup (Solution to Automating Status Rollups - Quip) and followed it exactly. It worked great. Recently for some reason recently every time the "Auto Status Rollup 1" automation kicks in it ends up giving me the "A workflow has become…
-
How to convert multiple email separated by commas from Text column to Contact list column?
I have a text column that has multiple emails and each email is separated by commas and i am trying to pull those multiple emails to contact list columns (I have allowed multiple contacts per cell ON) and be able to send alerts. However, when I do that it just stays as text, not contacts. Does anybody have any idea how I…
-
Request an update automation broke randomly
Hello! We have had a request update automation in our sheet for years. The idea is very basic, to assign a contact to a cell and they receive a request to update other cells on the same row. This has worked perfectly up until the evening of 4/15. After that, the automation has not been working correctly. In the below…
-
How to request update only for certain people?
Hello, I am making a ticket tracker sheet and am not able to figure out this road bump. I have a sheet where there is "additional information" column. When i type in that cell I have it automated to where it will be sent back to the requestor with the "Request and Update" email option where they can then type in the…
-
Enable File Handling in Bridge
Make it possible for Bridge to hand files as variables and results from actions. The example being a SharePoint API call returns a file that will then exist in the reference data of that complete action. This file/reference could then be used in future actions such as another API. My scenario required the use of the…
