-
copying rows to RAID log
Howdy, partners - I'm trying to use the copy row automation to copy tasks into a RAID log when a user identifies a risk or issue in our Project Plan. Our plan has a few sets of parent rows, and I'm finding the copy automation is not bringing just the direct parent, but the entire sheet into the RAID log. This is obviously…
-
Hiding or deleting content via Automations
I have multiple sheets following a complex workflow. When some of my workflows are completed and moved to the next step in the process, I want the row of information on a sheet to be automatically hidden or deleted. I see that we have delete a column, but not a row. I need my row to be cleared after the data has already…
-
Is there a way to use Automation to update a Duration column?
I have a helper column currently that checks to see if a task is required or not, and I want to set my duration to 0d if it is not required. Right now, I am doing this manually as I can't see a way to get automation to update a Duration column using the "Change a Cell Value" option. Is there a way to do this via Automation?
-
How do I "check a box" in one sheet based on criteria from a separate sheet?
Ideal Outcome: I get weekly training reports generated to sheet "x" and when someone is marked as "complete" in the training reports, I want to have a box in sheet "y" be checked. Is there a way to automate this process without copying loads of unnecessary data into the tracking sheet (sheet "y")
-
Automation workflows that were working are no longer emailing gmail and msn addresses
Our existing workflows that trigger automated email alerts have started failing. It started in the last day and only affects gmail and msn addresses from a contact column. The failure message is, "Due to a recent automation permission or sharing change, the following people aren't receiving alerts from your workflow".…
-
Can i move child rows to another sheet and copy the parent row across too?
At the end of each quarter, i'd like to copy parent rows and move the previous 3 months (from each parent row) to an archive sheet. Is this possible? I'd then like to have an automation after this that adds 3 new rows under each parent row once a new quarter begins.
-
percent column - are we all just guessing?
We're implementing a new template set for projects after some great sessions at ENGAGE. I'm writing some automations and getting things ready for end users to test but I keep coming back to the percent column. I'm stumped - how are others selecting or defining their percentages as a project progresses? How do we…
-
Automate reminders for Update Requests
I would like the ability to automate reminders for pending Update Requests where the user has not yet responded. When the user submits the update request, the reminders would stop. Ideally it could be built into Automations to select pending update requests and send a reminder after X days or within X days of a due date,…
-
Automation Help: Regarding Proofs
I want to record a date, when certain people approve a proof. When I set up a proof I am inviting several people, however, I need to record a date when a specific person (technically it could be 1 of 3 people) actually approves the proof. I have the {Proof Approved By} column (and as everyone approves their names appear in…
-
Automatisierung
Hallo zusammen, die Automatisierung läuft gerade sehr schleppend. Ist ein allgemeines oder nur mein Problem? Auf dem US Server scheint es Ende Oktober ein solches Fehlerbild gegeben zu haben. Beste Grüße Uwe