-
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…
-
Automation - Trigger when date and time reached - change time to 15 min increment
When building automations, the handiest way to test is to set the automation to trigger when a date/time are reached. However, only having the option to set for the hour (6:00, 7:00, 8:00, etc), means that after testing, and discovering a tweak needs to be made, one must wait until the next hour to test again. This results…
-
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…
-
Adding email list for Automations
Hi All, I have a Drawings Sheet that I use to update contractors with up to date drawings, I send them a simple published URL but do not share the sheet with them. (See below) I use another Project Sheet to run the project and keep a status of the jobs. In this lists all the contractors with a Purchase Order for the works…