Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Automatically figure out household #s in a Client Database

2513 5
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?

Hope_Center_Vol
5 - Automation Enthusiast
5 - Automation Enthusiast

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!