You would just need to create a formula field that uses the COUNTA function.

So, if you have 3 fields/columns named “Column 1”, “Column 2”, and “Column 3”, your formula would look like this:

COUNTA({Column 1},{Column 2},{Column 3})

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. If not, please let me know what else you need help with!

THANK YOU I actually love you about now

Hahaha, my specialty is making people fall in love with me. :winking_face:

I like you a bunch, but love - that’s a ways off. One step at a time.

@Michelle_King - just curious, when you felt like you were going insane, was it because you expected another column (i.e., a number field) would have the ability to apply the formula necessary to compute the aggregated counts? Or, was it something else that confused you and prevented you from understanding that a formula field was necessary?

Honestly its because I am used to the formulas in excel so I am used to their format and so tend to use the shortcuts on there - using the & button took me ages to work out lol

lol you obviously havent spent as long as I did trying to work out the formula