I'm hoping you can help! TL;DR in the weeds - I'm looking to use a change in the sheet to trigger an automation - but only act outside of the actual trigger TLD;DR big picture - I actually simply want…
I set up the automation shown below to transfer a row to another sheet once a check mark is selected for said row. However, when the automation runs, it transfers the entire sheet to the "Past Eval Re…
Currently we have a form that adds rows and "dealers" onto a program. I have been having issues finding a way to make that form or a separate form have a way to allow a drop down of the enrolled "deal…
Would love to see a feature to remove duplicate rows in a sheet. I have an automated rule setup to move rows into a sheet every day and some of the rows are duplicates. I would like to automate the pr…
I have parent rows (upcoming week, current week, and past weeks) and I'd like to be able to change the status cell from upcoming week to current week, and have it move the row under a different parent…
My workspace has 3 main source sheets. Each of these source sheets currently uses a different column for the primary column (two use ID Number, one uses Name since ID number is assigned later) but bot…
We are using a sheet to track a project we are working on. I have set up conditional formatting so that when the project status changes to "Completed," the entire row greys out. Is there a way to move…
I had an automation that I created that had previously functioned. Basically the user check a box in a column and once the check box is selected the row is deletes in the original sheet and should app…