-
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…
-
Showing only those selected fields with a value in the Approval automated workflow?
Hello. Another Automated workflow question. Is it possible, within the 'customised message' where we select 'Specific fields', that there is a setting that will only show those fields if they have a value? So, for example, someone completes a form, and certain sections may not be relevant, but the automation is set up as a…
-
Automation: sending a row with comments & attachments
Hello, how can I set an automation to send 1 row to a colleague (who does not have access to the sheet). The automation needs to send all attachments & comments related to the row being sent. Thanks, Becky
