Lisa_Wetherby - profile

Lisa_Wetherby · May 27, 2024

Hi - I use this formula to figure out when to follow up with applicants: DATEADD({Initial Email Sent}, 2, 'week') But I'd like to have it return a different result (1 week vs 2) when my applicants are getting fast-tracked. I tried this: DATEADD( IF(...

Lisa_Wetherby · Apr 09, 2024

I have a grid view with a field that shows volunteers that have volunteered along with the date they volunteeredI want to figure out how many volunteers volunteered each month - how do I find how many unique volunteer names appear in this list, and i...

Lisa_Wetherby · Feb 12, 2024

I have a table where static information about my volunteers lives.In it, I have a field (Static Notes) with an IF statement that looks to see if they have a check mark in "Qualified" (to walk dogs) and if they do, it returns "DDW" (designated dog wal...

Lisa_Wetherby · Feb 07, 2024

I have a form that I am editing using the "new form designer" - aka Interface Designer.I am adding some new questions that should be in a group - and all of my old questions seem to be in another group.Can I put the new group INSIDE the old group? Or...

Lisa_Wetherby · May 17, 2023

So I have this automation set up so that if there's no email address where I expect it to be, it can try using another field - but it's getting hung up on the if step. Isn't that the whole point of an if->otherwise condition set up?

Lisa_Wetherby · May 30, 2024

Nope.I thought the problem might be that Send Initial Email is a field and Initial Email And FastTrack Initial Email are options in that field, so I played around with that some. Still didn't get it to work.

Lisa_Wetherby · Apr 12, 2024

Thank you! That is a simple way to get what I need - which works for me!

Lisa_Wetherby · Feb 13, 2024

Well, that looks good, but it's not working. I feel like that is often the way with Airtable.I had the formula written already for DDW and was trying to add in Trainee. It's still working for DDW, but no joy on the Trainee front. Sigh.

Lisa_Wetherby · Feb 08, 2024

Thanks - not the answer I was hoping for, but still useful - appreciate it!

Lisa_Wetherby · May 03, 2023

It's turned on, being triggered and then throwing the error. I just tested it with a different record and it worked - but I think the problem is that it's pulling data from the wrong table. I can't see how to specify which table to pull from.

User Statistics

User Activity

DATEADD & IF

Count unique values in a column

Can I write a formula that will include info from different fields?

Interface: Nesting Groups?

Automation If->Otherwise fail

Re: DATEADD & IF

Re: Count unique values in a column

Re: Can I write a formula that will include info from different fields?

Re: Interface: Nesting Groups?

Re: "Message" could not be converted to a string.