Automatically figure out household #s in a Client Database

[Hope_Center_Vol]

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

[Mac]

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

[Hope_Center_Vol]

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.

[Mac]

Try this: https://airtable.com/invite/l?inviteId=invbQ6eNzDimRDcKR&inviteToken=71b442689a12f2d6ad74d164b779b00...

[Hope_Center_Vol]

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

Thank you so much!!!

[Mac]

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