Automations
Discussion List
- I am working on a project, and there will be MANY times that there will be multiple requests. This column is a dropdown with 2 options, "Yes" or "No". If the response is "Yes" I would like the data fr…
- Hi, I am trying to create a master sheet with information I need that pulls specific cell data from multiple different project sheets. I know I can use vlookup's and reference another sheet within the…
- I have a dump sheet that needs to be clear every day. Move row does not work, its adds another step into a simple task.
- Hello, After someone completes a task on my sheet it sends out an approval automation for the requestor to Approve or Deny the work that has been done before moving it to a completed sheet. Is it poss…
- I'm using an Assign people automation to fill in contacts for several roles based on criteria or check boxes entered on a form. Each condition path should add a name to a different cell. It's only add…
- I have a sheet tracking facility access qualifications for contractors; I need to change the status ball for a previous entry when a new row is created of the same contractor. Basically, when "Ron Coo…
- I am trying to figure out how to have a "status" change to past due if the due date occurs and the status is not "complete." Is there a way to do this? Thank you!
- Hi, I have below automations set for a sheet that gets the values from another sheet by index(match) function, and that another sheet is being updated on a daily basis. As can be seen in this example,…
- Hi, I want to automate the status column of the parent row based on the child rows. For example, if all of the child rows are left blank or marked "Not Started," I want the parent row to read, "Not St…
- I am trying to create an automation that changes a cell when another cell changes. For example: When status column field changes to On Hold, the Health column field is to change to the yellow circle (…
