Amy_Herman - profile

Amy_Herman · Jan 07, 2021

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. ...

Amy_Herman · Dec 09, 2020

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...

Amy_Herman · Oct 14, 2020

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?

Amy_Herman · Oct 08, 2020

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...

Amy_Herman · Oct 01, 2020

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...

Amy_Herman · Mar 01, 2021

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...

Amy_Herman · Dec 09, 2020

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...

Amy_Herman · Oct 14, 2020

Hmm I tried a few times and cleared my cache. I’m working on pulling this info another way.

Amy_Herman · Oct 08, 2020

@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!!

Amy_Herman · Oct 08, 2020

Woohoo! I got the Lookup field to work. Unfortunately, I’m still getting the error I mentioned above. Here are some fresh screenshots.

User Statistics

User Activity

Automatically assign next value from list

Nested if statements for attendance tracking

TO field cannot be empty error

Reference looked up emails for automation

Pull multiple values into one cell

Re: Automatically assign next value from list

Re: Nested if statements for attendance tracking

Re: TO field cannot be empty error

Re: Reference looked up emails for automation

Re: Reference looked up emails for automation