-
Can I sum two cells together and then clear the contents of one cell without changing new total?
I have two cells that I would like to sum together based on a check box. When Order Received is checked, Quantity Delivered is then sent into my total inventory in row 1. I would then like to clear all of the contents of row 2 through an automation, because that order is complete and done with, without changing my new…
-
How to replace an SOP in a row when that row is updated
Hi everyone! I am creating an SOP Tracking system for my company where I will track all SOP’s being created. That being said, I need to be able to replace an SOP when the SOP is updated. Can I do this using either forms or automation? The SOP will have a specific name associated with it that will be able to be matched when…
-
Copy Row automation brings original sheet 'Created date' instead of showing date it was moved
Please help, I have a helper sheet that I am using to capture time stamps of when a row goes to different statuses (ex: capture time stamp when request status changes from: In Review, Pending Response, and Completed). To do that I set up a copy row automation that triggers when those statuses change. Then it copies the row…
-
How do I pair things on the sheet with the same request # if they come in at different times?
I have a request sheet. This sheet is used for product launches, the goal of the sheet is to be able to request multiple days to launch the product . Some times these requests dont come in at the same time from the same person. This means that person A can make a request . Then person B can make a request, and If A makes…
-
Recurring workflows based on date field in sheet
Hi, currently my options are - run once from a date field and run recurring based on a specific date but it would be really helpful to be able to initiate a recurring workflow from the date populated on a row. I have investigated some of the community suggestions for helper columns but I have up to 6 actions on a row that…
-
Change "End Date" based on status change?
Hello, all! Is it possible to change the "End Date" column based on when someone completes a task? Sometimes my team finishes a task on time. Sometimes it's a few days late. Sometimes (like today), a person finishes nearly a week early! Of course, if the end date is off, that messes with all successor tasks. We're doing a…
-
How to change automation of a form to notify the person who filled out the form whenever a change...
Is there a way to set the automation on a sheet so that the specific person who submits a form, gets an email back when a change has been made to the row? I am trying to create a request for time off form. An employee can submit the form which flags management, then management will select a drop down for approve or deny in…
-
How to count total number of times a value appears in cells with multiple values.
I have been trying to find a formula to use that will let me count the total number of times a day appears in this column. I would like to ultimately put this info into a graph on the dashboard. Is there a way to do this? I have tried using the COUNTIF with CONTAIN and I haven't been able to figure it out while on a…
-
Allow display of destination sheet full name in the Edit Automation dialog when moving copying rows
This is a simple request to allow visibility to see or display the full name of the destination sheet in an existing automation. Here is the use case: 1) I have created an automation whose action is to move or copy a row. 2) The name of a destination sheet that is selected is longer than what displays in the Edit…
-
Editing the Auto-Message Form (Approval Workflow)
Is there a way to remove fields from the email request when setting up an approval workflow? Right now the approval request displays all the fields from the sheet and I would like to only display the fields the approver would need to see.
