Skip to main content

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

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


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.


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.


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


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



Thank you so much!!!


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


Reply