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 comp…
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 spec…
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 w…
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 templat…
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 al…
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 …
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…
I've been usign columns references in the text of my automations messages a while now. It looks like that. The text is in french but you can see the symbols used. Bonjour {{Fournisseur}} Voici la conf…
Hi I have a bit of an issue that I am struggling to solve myself. I have a worksheet with that gets updates via data shuttle with a list of employees nominated for a performance award. I want to colle…
Hello, I am having issues with automations not updating to show the custom subject line I entered for emails. I am not sure what I am doing incorrectly. Can someone please review the screenshots below…