-
Customisation of emails not working????
I use automation a lot including notifications and update requests. To limit the receiver's access to only the fields I want them to update (otherwise they go wild) I select the fields for update but put all the other pertinent (not to be changed) information in the customised message using the {{field name}} function to…
-
Last Modified and Latest Comment fields for rows copied via workflow automation
Hello, I have a workflow automation configured that copies a row from one sheet to another based on certain criteria. Two of the columns that are copying based on this automation are the Last Modified and Latest Comment (AMAZING addition, btw) fields. Over in the destination sheet, these two fields seem to retain their…
-
Sheets in Reports
Hi there, I have a question and an answer is greatly appreciated! I have a report that pulls data from standard sheets across all workspaces we have. I need that same information to be pulled from every newly created workspace in the portfolio without me having to add those sheets manually. Is there a way to automate that…
-
Automation Error
Not sure if this is the right place for an automation error or not. I have previously asked about returning a value once (not sure if my link would work for everyone or not). I was able to get it to work with a metrics sheet, a helper column, and a copy rows automation. However, the ID I used for that one, is only valid…
-
Is it possible to set up a recurring update request that keeps sending until all cells are updated
Hello, I've set up a sustainability tracker for a team at my organisation and they are hoping to limit who access to it, whilst still wanting input from certain collaborators. My idea to achieve this would be using an automated workflow - namely an update request. I'm wondering if it is possible to set up the update…
-
"Change Cell" Automation Not Working
I have created an Automation that auto-assigns a technician based on names in another cell within the same sheet and it is not changing my cell values: The Trigger is set for when a row is added (rows are typically added in bulk as a copy paste from an Excel File) The "Audit Assigned to" Field is a single-select dropdown
-
Workflow to Automate Document Generation?
What's the simplest process for using "Document Generation" when a new "Form" is submitted? Does anyone have a workflow that can automate this process without the need for a "Gatekeeper" or someone manually generating the row-level document after the form is submitted? Example - We have a PDF form that requires a signature…
-
Error Creating Charts Without Info in Template
I created a few charts in my template but because there is no information in the sheets (because it's a template) the charts show an error. Wouldn't typically be a concern because as soon as the template is used the information will be populated and the chart wouldn't error out. However, when I use this template in control…
-
Alerts but send populated Fields only
The form I use to gather data is made up of circa 150 columns, and different columns are populated each time a form is filled out, depending on options selected in the form (logic). When I set up an alert, I just want it to send populated fields so they don't have to scroll through a big list of empty fields to see…
-
Any way to have a formula automatically change input when a set of new rows added?
Hi, trying to automate a process whereby the change from week to week on a project is reflected in a graphic on a dashboard. Right now, I have the source sheet for the data copy the rows to a separate sheet once a week. I want a formula to simply find the difference between last update and the new one. This is what will be…
