-
Change Cell Value Automation - flag or symbols
I am wondering why you cannot set the value of a flag or symbol using the Cell Change Value Automation? I cannot see how to do it. I have a flag column that I want to let the users manually set to highlight what needs to be looked at and also have the flag set automatically when certain conditions are met. I can't use a…
-
Duplicate Alerts
Hello! We have a sheet that is sending 2 update requests each week to each recipient. It's a very simple automation and the update history only shows one notification going out. Does anyone have any idea what could be going on? Thanks in advance for your help!
-
Automation / VLOOKUP help
Hello! My initial gripe comes from wanting to copy only certain cells from a row into another sheet. I've read a bunch of the threads for create a helper sheet, add dummy columns, and then use VLOOKUP, but I just cannot get it to work for myself and I'm uncertain what I'm missing! I have Sheet A that contains all my raw…
-
Automation: Sender issue
I have 3 coordinators working from the same sheet. Their case load is determined by last names, A-L and M-Z for the 2 coordinators and a specific program assigned to the 3rd coordinator. Anyhow, the delimea we are having is that when the automation for assignments go ount on trigger, it appears that it is coming from the…
-
Change Cell Value with Automation Workflow
I have a scenario where three people are providing an update on a project from different aspects, we have 3 fields for each person so the update requests prevent people from overwriting others update. We then would like to concatenate the 3 fields into one. Putting a formula into the field makes it hard to read without…
-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Automatic Mirror for Sheets Associated with Forms
Presently, the Sheet that is connected to your form does not automatically arrange the columns in order of the responses on your form. It would be helpful for the Sheet column order to mirror the forms responses as the standard and then allow you to manually arrange if you wish to have a different order. The manual…
-
Automate Group membership management
Idea is to automate group management based on some users' information like: email domain Licensed/unlicensed Active/Inactive User description or attribute that can be used to enter text to be used as filter And also schedule report to send group membership to group owner.
-
Sheet automations and cell updates
We have a recruiting team for our clients. When the client requests us to fill a job role, they can specify one or more jobs in that role. When the recruiter fills one job, I copy the row to another sheet for billing, then I want to reset five key fields and decrement the number of jobs to fill. Does anyone have any…
-
How to set up automatic notification when entire column meets the criteria?
We are trying to build a monthly checklist with various tasks our team members need to complete. Some of these tasks need to be completed before another task on the checklist can be completed. Specifically, we need our users to upload their payroll cash batches into our accounting system before another user can populate…