This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi helpful people,
I have a list of voucher codes. When someone fills out a form requesting a code, I’d like to update their record with the first unused code on my list.
I’m stuck on how to update an existing record with a value from another table. ...
Hi!
I’m stuck on a formula for tracking attendance.
IF({Attended 10/23}<>1,
“New”,
IF(AND({Attended 10/23}=1, {Attended 12/8}=1), “Yes”,“No”)
)
I have had 2 classes, and I want to know how many people who came to the first one (on 10/23) also came to...
Hi there,
I’m trying to set up a Gmail automation, which I’ve done before just fine. For some reason, I keep getting the below error when trying to add in the Email field I have.
Does anyone know why that might be?
Hi there,
I have a communications calendar that I’m trying to have automate some email sends through the Gmail automation. I have my emails on that table as a lookup field, but the automation isn’t recognizing it as an email address so it’s failing t...
Hi!
Hoping someone has done this before.
I have a list of customers and their email addresses organized into groups. So I have 3 columns: customer name, email, and group #. I’m looking to make a new table for email automation. I’d like to pull all em...
Hi there,
I have one sheet with a long list of redemption code and a separate one with users. I am stuck on a formula to automate pulling a redemption code and assigning it to a user automatically when a third field on a separate sheet is true.
The u...
Yes, I’m using those for some other purposes, but since I will eventually have 10-12 classes to keep track of, I’d love to have a dashboard or something. :confused: You’re right that will get me an immediate answer though! I will set that up in the...
@Kamille_Parks I think the ARRAYJOIN() fixed it! I think you and @ScottWorld are going to keep me sane. Thank you for your help (and for repeating yourselves). I have my automation set to run tomorrow, so wish me luck!!
