-
Can I have just one cell automatically copy over from 1 sheet to others when a new row is added
I know there is a workflow for copy row if row is added or changed. I don't want that, since it will copy all of the columns. I have 1 Master List of Names. The other sheets are specific trainings and prerequisites. I will have columns on the master list that don't need to be on the other sheets, and vice versa. I figure I…
-
Automated Workflow - omitting relevant sheet content in subject and body
Good morning Community! We currently have a solution with an automated workflow that runs on a schedule when a date is reached, at 7 am PST. We use INDEX Match that populates specific fields from a reference sheet that is generated through an API. Each night the API clears the reference sheet and repopulates the…
-
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…
