-
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!
-
Attach an existing Dynamic View to a sheet programmatically
I know there is no API for Dynamic Views yet, but I'm looking into building some automation for a client and wonder if there is a way to programmatically assign an existing Dynamic View to a new sheet. It doesn't look like when you copy a sheet and create a new one via API, the Dynamic View associated with that original…
