Can fields reflect information from multiple records?

Hey there! Check out this sample base :slightly_smiling_face:

Welcome to the community, Michael! :slightly_smiling_face: You’ve definitely got an interesting problem here.

This one can be done with a minor tweak to a solution I came up with a little while ago:

In your case, you want the count to be persistent on all relevant records, rather than increasing with each new instance of a given number/item. To do that, you would skip the third step in my bullet-point breakdown of the process, and use this formula in the next step (the {Substitute} field:

SUBSTITUTE({Lookup A} & "", A & "", "")

In my test, I simply named the first two fields A and B, so this formula replaces all instances of the A number with a blank string. Then the fourth column in your example becomes this formula:

LEN({Lookup A} & "") - LEN(Substitute)

Here’s what I’ve got so far with that in place. The {B Sum} field is where your Column 3 solution will eventually go if I can work it out. It’s more complex than Column 4.

While finishing this post, I saw the reply from @AlliAlosa come through. It uses a similar approach for Column 4, and a clever way to get Column 3 figured out via links. However, I get the impression from your original post that the data in Column 1 would be entered directly, not linked. Please let us know if the link solution will work, or if you need another option.

thank you so much! I just got done with work and just got to look at this, I will mess with it tonight and let you know. this makes a lot of sense though.