-
Using duration column for automation workflows
Hope you are well! I'm using this function: https://help.smartsheet.com/articles/2479251-condition-blocks-filter-what-your-automated-workflows-send However, instead of generic numbers, I want to use the duration column for the condition like below: I tested it and it's not working. Is there another syntax I need to use to…
-
Is there a way to add a new summary field from a master project template?
Wanting to create a project template that allows me to add new summary fields and have those summary fields populate all of the sheets created with the template, is this possible?
-
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…
-
Problem with alerts related to changing dates
A default date of 01/01/00 is used in the "Decert Date" field. We want users to be alerted when the 01/01/00 date changes to 'something else'. However, we DO NOT want users to be alerted when the 'something else' changes to 'something yet again'. I used the below setup but still received unwanted alerts. Any…
-
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…
-
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!