-
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…
-
Set Workflow to a specific cell/row not the column
Hi! I'm trying to set up an automatic workflow that will trigger an email alert to a person when a particular cell has been populated but can only seem to be able to do it for a column and not a specific row. Example is: Person A is assigned a client. When Person A completes Task 1, Person B is to Peer Review that…
-
Email Notification : How to Remove the "Personal Email" on the "Changes made by" details
I saw that there were recent updates regarding email notification we set up through Automation. We can now choose "Send from Smartsheet Automation" and "Send from my organization". Currently using the option "Send from my organization" and then the messages includes "Links to sheet and specific fields" option on the "Alert…
-
Email Notification : Removing the "Personal Email" on the "Changes made by" details
I saw that there were recent updates regarding email notification we set up through Automation. We can now choose "Send from Smartsheet Automation" and "Send from my organization". Currently using the option "Send from my organization" and then the messages includes "Links to sheet and specific fields" option on the "Alert…
-
Automation to move rows stopped working
I have an automation setup to move a row to another sheet when the status us changed to "Complete". This automation was working fine until I upgraded from Business to Enterprise. Now the automation does not trigger automatically, and when I trigger it manually it moves all rows from the source sheet to the destination…
-
Managing fields displayed in an automated update email - placeholders?
I need to create an automated update message that will be sent to executive leadership. The message contains three columns from eight rows on my project sheet and has a link embedded to the published sheet. (See below) I need to remove the link automatically inserted at the top of the message. I tried placeholders (which I…