-
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…
-
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
-
Merged: MORE SORTS ON REPORTS
This discussion has been merged.
-
Formula or Automation Help
Im looking for the best way to set up this formula/automation (whichever is best): I have multiple columns collecting different contact names by title from a form: I need a formula or automation, that when "Admin Reviewer" = yes, then it takes the contact in "Project Admin" and adds it to another column titled "PT Proof…
-
Workflow emails without attachment only show the subject line in a mobile/web environment
Sometime between 10/21/2024 at 2:27 pm and 10/22/2024 at 7:33 am my workflow emails stopped behaving predictively in a mobile environment. I have an automated workflow that sends a summarization of information to field personal upon submission by a project manager. This info may or may not include attachments. These…
-
Systems and Services subscription renewal dates
I have a sheet which tracks the various systems we use and their monthly & annual subscription charges. We'd like to have SS tell us when a renewal date is approaching, particularly with the annual charges at first, but then have that date push out to one year (or month if it's monthly). A notification email would then get…