-
Automation Custom Recurrence - how is the "Repeat On" day defined?
Greetings, Does anyone know what is the reference point for the "Repeat On" day circled below in the Custom Recurrence section for Automation Triggers - is it referencing the day of the month or the number of days after the trigger initiates? The reason I ask is, I set this recurrence to start on 20 Sept. Originally, I set…
-
"Changes to:" Option Not Showing Up In Automation
Hello, This is not populating when I am trying to add a specific person from a dropdown list: The goal is to select certain team members that will be involved on a project so we can send rows (tactics/projects) to team member's sheets from the project lead's sheet. Can you help? Thanks, Ryan Holguin
-
How to copy a column data of a source sheet to a target sheet.
Hi All, Step1 - I would like to copy the column data in a source sheet to a target sheet. Step 2- After the data is filled in the target sheet column, I will then run a data mesh config to pull the rest of the column data by matching a data I copied in step 1. Below is some screenshots of the sheets: Coulmn114 data is…
-
Trigger an Automation after an Event is over (Time specific workflow)
Hi everyone, I manage producing events in higher ed, and I'm trying to set up a workflow which sends a recap automation to our workers after an event is over. This is to collect notes and details with information from boots on the ground to help build reports and dashboards. In our sheet we have a column for date, and then…
-
Alerting Contacts in a cell
Hello, We have a sheet that we use as an IT ticketing sheet and Form. I setup an automation so that whenever a comment or attachment is added to a row it will notify (email) whoever the assigned technician on that ticket is. This works great when the end users comment, however, when the IT technician makes a reply or a new…
-
Upcoming changes to our automated notifications - live today 17th April 2020
Today the proposed changes to automated update requests / notification has now got the OWNER's name in the email. This is causing us absolute chaos. Update requests have been sent out and as they now have the owner’s name (in our case this morning Kirsten Cox) the owner is now receiving lots of emails from people asking…
-
Merged: Workflows Trigger Timing: Date-Time Customization
This discussion has been merged.
-
Conditional Repeating Routines
Hello SS Community: I'm a big fan of automation and something that would help a lot would be the possibility of conditional repeating routines (IF-THEN-ELSE) and using formulas using data from the worksheet, as part of an automation. This would allow sequential tasks to be performed, such as creating a certain number of…
-
What formula to use to add $ and comma in the field
I have a "run-rate" field that sums up values from 4 other cells. What formula can I add so the summed value automatically has the $ sign and comma between the numbers? Also, can I use the same formula in the other 4 cells so that people don't have to add $ and comma when inputting data? Thank you
-
Recurring Cleaning Schedule Setup
I'm helping my Laboratory Department setup a Tracker for a Cleaning Schedule that has a variety of pieces of equipment that each have a different time range of when they need to be cleaned (from every 2 weeks to 6 months). I had it in my head that I could use Gannt functions to setup the varying Durations of each piece…
