- How to trigger an automation after a row is changed but on a future date
Hi, I want to move rows to an archive sheet if the user clicks a box saying "Yes Move this Row" but I only want it to happen after a date in a separate column has passed. I have automation set up for Triggers: "When Rows are changed" and "When 'Yes Move This Row' is checked" and "Run when triggered " With the condition…
- TODAY() Automated workflow birthday not calculating correctly
We've automated a work flow for birthday notifications - so we can celebrate folks. The workflow/notification shows an incorrect calculation - age = 20, when it should be 21. Here's the notification: And here's the data we're pulling from, showing the correct age calculation: I'm assuming this may have something to do with…
- Workflow not sending emails
I have a very simple workflow that is not sending email when rows are added. I have been testing with me doing the entry and I don't get emails. My notifications and Automation Permissions are correctly set. Can anyone provide insight or suggestions?
- Mismatching cells notification
I'm trying to create a notification if two cells do not match each others values. We currently would need this is a production environment where a PO quantity is created and as the item is produced, if the department doesn't log the same quantity as the PO, the notification is sent to the supervisor. For example. IF PO…
- Send automated alert from another user or group
Is it possible to change an automated alert email to send from another user or group to that of the sheet/workspace owner? I am the workspace owner and email messages are delivered to customers from me: Can this be changed to a different user or group email account without moving the sheet to another workspace that is the…
- Automation with time & rows added
Hello, I am trying to figure out a way to send an alert when a new row is added AND have the automation run at a particular time of the day. If I understand the way the automation is configured, you can choose one or the other. Is there a way to say: If a row new row has been added as of 9am send an alert. Check again at…
- Automating Date fill in other than Today?
I am trying to figure out if it is possible to use the automation function to essentially say, "when column A is filled in, mark in column B Today + 1." I'm not sure this is possible, but I wonder if anyone has been able to accomplish anything similar with the automation function. I specifically need this to be an…
- Approval Workflow with Attachment in Response
I'd like to design an approval workflow wherein I need to automatically attach the same PDF file in all of my Approved Response email. Would that be possible? or my only option is to include a download link from Onedrive or Googledrive in the response so the recipients can get the PDF file?
- Average/Roll Up Harvey Ball % Complete Symbol in Parent Row
Hello, I have a feeling this is going to be so simple, but I cannot seem to figure out how to average the values of the Harvey Ball % Complete symbol in a parent row. Per my screenshot, I want the Harvey Ball with the red arrow to average the values of the Harvey Balls beneath it. There is a parent/child relationship…
- Unique countif on a multi-select use case
I have a sheet where we are trying to do a count of project for each person. Here is the information: The sheet lists all the services/applications that a team supports. There are potentially multiple team members assigned to support a service/application. We also have projects that may or may not span across the…
