-
Nested IF statement for multiple date range
Hello! I am currently attempting to write an all encompassing formula to read through different work windows. We are only able to work in certain areas of the city depending on the "work window". Depending on the work window, these dates have differing start and end dates. I can get one window to work properly, but the…
-
automation for moving specific columns
To move specific column values from my source sheet to another sheet, I can't use a lookup formula because the entries in the source sheet are constantly changing and not permanently established. In my second sheet, a new row should always be added with values from certain columns from the source sheet. The row should be…
-
Is it possible to get automated alerts upon change to a report
I have a report which is being populated from 150 separate sheets being used to track project approval stages for 150 projects. I would like to be alerted anytime that a project stage approval is completed. Is there a way to get an alert when a report changes (as opposed to manually checking the report every day? Or…
-
Automation
Hi everyone, I need to delete duplicate rows in a sheet. How can I create an automation to delete one of the "n" duplicate rows? How can I create an automation that deletes a row completely under specific conditions? Also, is it possible to highlight duplicate rows with conditional formatting? Thank you!
-
How to change the Run Workflow Timing?
Hello- I am working through some automations and I may have put myself into a bit of an automation circle and am now trying to fix the issues. I am trying to get my new automation to run hourly, but when I try to switch it I am getting the error in the picture below. Does anyone have any idea of how to get an automation to…
-
Automation Help - Alert e-mail with attachments
Hello! I have set up an automation for a sheet so that when a contract is executed. When there is a request for a new contract, an employee completed a form that includes attachments. The completed form adds to the sheet, and another employee begins work on the contract. The employee adds the date to the sheet that the…
-
Can I automate sub task numbering
What I'm looking for is to assign ascending numbers to each sub task, starting from 1. Like how I have included in the photos. Update: I found the threat where people are talking about the WBS template. If you're reading this and you have not found it yet, here is the link…
-
Automation generating a grouped email as well as the correct one
I have an automation that runs daily to flag overdue reviews. Each individual notification seems to send fine, but people are also getting 2 duplicate emails that seem to be a consolidated email of all the individual ones sent (Third Image). The second image is what the normal body of the email just says, which includes…
-
Created By is automation@smartsheet.com
I have 5 rows that were added to a sheet and all have the Created By automation@smartsheet.com - I don't understand how a row would be created by an automation. It also didn't follow any of the usual workflows when a row is added via the form. Any insight on what would cause this would be great. Thank you!
-
Automations: include attachments
When selecting attachments for an Automation Workflow, we should have the option to include all the attachments in the notification email instead of sending only the last attachment if it was attached after the last save of the sheet.