-
Easy way to add contacts to a drop down?
I set up a workflow to add contacts listed in a sheet to a contact drop down of another sheet, however the workflow takes about 10 minutes to run since it is building an array with a child workflow. Does anyone have a cleaner way to take contacts listed on a sheet and update a contact dropdown?
-
Can i configure a workflow to alert someone when a specific entry is put in on a multi-select column
I have a form we are using to collect information on team activities. One of the form fields is a multi-select column where entrants can select all of the partner teams they will need to conduct the work outlined on the form. I'd like to send an alert to a "point of contact" for each team that is selected as a partner. The…
-
What happens to my automation if I run out of rows?
Hey there! I am working with a large archival destination sheet: We haven't hit 20k rows YET, but it'll probably be coming this year. The automation moves Completed rows from an active tracking sheet to the archive sheet- we keep that for a full accounting of these completed processes. But.... what happens when…
-
Send email reminders when lack of update
How do I create a workflow to send reminders to the row owners if no changes happened to the row in the past week?
-
Timing Issue for Moving Row from Staging Sheet to Main Sheet
I'm building a workflow for our HR and Recruiting department to use to track job posting requisitions. If they check a box on the master sheet to repost the job again I am copying the row to a staging sheet, making a few cell updates to change values or clear values, then want to move it back to the master sheet as a new…
-
Reset a Row
Hello, I am looking for a way to have certain cells in a row "reset" once a checkbox (in that same row) is checked. When I say "reset", I want two cells to go back to being empty and another cell to have an updated quantity. Is there a way to do this? Maybe multiple automations? Appreciate any help or ideas!
-
Setting up a trigger comparing today's entry with the last entry.
Operators will enter Paint Code, Line Speed and the Date is created at the time of entry. There are MANY paint codes. How do I create a formula or workflow or BOTH to notify a manager WHEN the paint code has a lower line speed than the last time it was entered? Example below.
-
Triggering a form to be sent to users after they fill in data in Dynamic View
Hi. How can I create a workflow that does the following : Once a user fills in data in the dynamic view of sheet1, a form will be sent to them from sheet 2? Thanks.
-
Workflow automation
we have workflows set up that are working beautifully. Until recently. There is now a duplicate workflow under my name/account and I can't figure out where it is pulling information from or where it is set up! Does anyone know how to identify where a workflow is pulling from?
-
Using a range of checkboxes for an IF statement
Hi, I have a column of checkboxes, and next to them are cells with just regular text. I want the text to be referenced in another sheet only if the checkbox is checked: I can get it to work for just one value fine with =IF({checkbox reference}, {personal goal reference}), however this is just one pair of cells and I would…