-
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…
-
How to reference Sheet Summary cell in the text of an automation?
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 confirmation de commande pour le projet {{Projet}}. La date de début est le {{Date de début}} La date de fin est le {{Date de…
-
Question about collecting feedback via form or request update
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 collect feedback from their respective unit managers on specific criteria. The feedback is a numeric rating that answers specific…
-
Automation isn't updating my email subject line as I had entered - what am I doing wrong?
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 and advise me? Thank you! Here is what I expected to see in my email: Here is what I got:
-
Approval flow status - need help
Hello, I am in the process of creating a sheet (two separate forms depending on requesting line of business). My team handles one operation while my peer handles another. I have the automation when forms for specific lines of business it will send our respective teams an update will be sent via email. I also have a hidden…
