-
How can I tell where the automation email fail is coming from?
My IT Dept. says Smartsheets is whitelisted. They show no record of any emails getting blocked. However, my automation is to send an email when a row is added from a form and now no emails are going out to anyone. I even tried Run Now and nothing is going out. Is it Smartsheets? Is it down? It worked two weeks ago when we…
-
CopyRow Automation Not Working or Glitching
Hello All, We've recently had a few issues regarding the CopyRow Automation. We have our stakeholders submit project request from the source sheet to a project tracker/list sheet (destination sheet). However, there have been a few cases recently where the automation didn't run when all of the criteria were met, causing…
-
Assign Contacts to Child Rows Based on Criteria in Parent Row
We have multiple stages in our projects that are set up with a parent row and then child rows below. I would like to assign a contact to the parent row of a stage and have that contact automatically assign to all child rows below. Is there a way this can be done without add-on software?
-
Automation notification to Shared email account.
Hi good afternoon, everyone. I am trying to set a Shared email account into the notifications automated email every time that someone add a new item in a sheet. Unfortunately, I receive this message when I input the email. Any solution to this? What i am looking is that every time that somebody submit a new item (via form)…
-
Automation notification to Shared email account
Hi good afternoon, everyone. I am trying to set a Shared email account into the notifications automated email every time that someone add a new item in a sheet. Unfortunately, I receive this message when I input the email.
-
Notify someone if no rows are added or changed everyday at specific times
Hello, I am trying to set up a sheet where there are two people being notified to complete and submit a checklist twice a day (already set up to notify them each at 9:00AM and 1:00PM). I want to create an automation that sends a notification to my boss if there is no submission by any party at the end of the day (5:00PM).…
-
Multiple Actions on "New Record"?
Since some automation actions are "terminal", meaning that no other actions can happen after these, I tried making several independent automations that all trigger off "When rows are added". Here's my 3 workflows that all trigger on New Row: 10 New record, Set Status - Actions: Change a cell 15 New record, Set Due Date -…
-
Automate Subtasks for a new row in a sheet
Hello! I have been working on a sheet that is primarily viewed in Card View. I have added subtasks to the cards. My question is, when a new row is added in (when you are in Grid View) is there a way for you to automatically have the subtasks added when there is a new submission? Hopefully this makes sense, thank you!!
-
Auto-numbering automation
Hello I have a sheet, that uses numerical ranks to keep track of projects. These ranks are simple number assignments (i.e: 1, 1.1, 1.2, 2, etc.), that we use to determine the priority of the project. If a project changes priority, or we have a new project that comes in at a high priority we have to manually update the…
-
Array and Index Training Records to pull who needs to complete something within a date range
I manage training records and am creating a dashboard to manage who needs to complete a training. I have a master sheet with the employee name, and a reference column to them completing the training and when it is due I then have a calculation sheet to count how many people fall within that date range =COUNTIFS({HiPot…
