-
Automation send alert to secondary email
Hello, When setting an automation to send an alert about new fields added to a spreadsheet, the alert arrives to primary email address even though it was set to be sent to the user's secondary address. How can I ensure the alerts arrive into the user's secondary email address only and not appear in their primary address?…
-
Form Submission creating new row - cant do notification
I have a sheet which has 10 columns. It is meant to collect data and trigger notifications. The first 4 columns, I have created a form to collect data from user. The 6 other columns are for tracking on status and assigned to user column. The last 6 columns are meant to be fixed (content doesnt change). So when a new form…
-
Date Automation is not working
I've got an automation set up in a way that if a row is added, the date gets captured. However, when adding data to a new row, this does not seem to work. I've even waited for 30 + mins since some discussions have mentioned a 'delay' in the automation working (however, I understand that this has now been resolved anyway).…
-
How can we create baseline chart
Hi How can we prepare the baseline chart to show each projects Original schedule and current schedule . Thanks
-
Problem with dates: day becames month and month becames day.
Hi. I am facing the following problem with date formats. In my source sheet, I have the following date: 04/12/20, which stands for 04/December/2020. An automation copies that value to another sheet, but in that sheet it appears as 12/04/20, which is 12/April/2020. I am doing anything wrong or is this a bug? If the day of…
-
Formulas to identify duplicates
My company is assigning decals to vehicles to monitor our guests. Is there a formula to identify if a license plate has already received a decal if I am looking at my sheet? We will have 2000+ license plates and need this to be a quick glance, or automated notification. I know I am asking a lot so any help is appreciated.
-
Proofing Automation
How do I use the workflow automation for approval with Proofs? For example, I need to send a PDF proof through a workflow to be approved, but I am unable to do this through automatic workflows (cannot add a Proof) nor the Proofing feature, which is not automated. Also wondering if I can use dynamic cell data in Proofing…
-
how can i see whether Automations are being sent?
It seems like we should be able to generate a report of all automations, but I don't see any way to do that?
-
Automated Workflow fields - can they be duplicated?
Hello knowledgeable ones, I have multiple workflows for approval/assigning within one sheet. In each of these workflows we want to send certain fields via the email. Do I need to select each of these fields for each (30!!) of the individual workflows? I cannot see how to copy and paste the relevant fields. I am assigning…