Help

Re: Automatically figure out household #s in a Client Database

1062 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Hope_Center_Vol
5 - Automation Enthusiast
5 - Automation Enthusiast

In our Client Database (for a small non-profit), we have a client table with all their information. If I have a field for each of their children (Child #1 Name, Child #2 Name, etc) - is there a way to create another field and use a formula to look and see if there is information in each Child field and if there is, add up the number of fields with information.

I have been trying to use COUNTALL or an IF formula and I can’t get it to work.

Thanks!
Jen

5 Replies 5
Mac
8 - Airtable Astronomer
8 - Airtable Astronomer

Have you tried a roll-up or just a lookup?

Thanks for giving me something to try! I’m trying them (again) today. But what I’m seeing is:
Roll-up and Lookup links to records in a different table. And, how I’m understanding it, it only looks at one Field (column) in that linked table. I want it to look at (up to 😎 mulitple fields. And right now I have all that data in the same table.

Hope_Center_Vol
5 - Automation Enthusiast
5 - Automation Enthusiast

Wow! I’m embarressed at how easy that was. It worked perfectly.

Thank you so much!!!

Mac
8 - Airtable Astronomer
8 - Airtable Astronomer

No worries! We’ve all have those moments! That’s what the forum is for!