+9I swear this must be really easy, in fact in excel it’s really easy what am I doing wrong :frowning:
I have one sheet on there I have a variety of columns I want to create a column at the end that says how many out of columns xyz (which are all single line text columns) contain text - please can anyone help as 4 hours later a rabbit hole of videos and posts on here I still cannot get it to do anything - thank you in advance
Best answer by ScottWorld
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! :slightly_smiling_face:
+35You 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! :slightly_smiling_face:
+35THANK YOU I actually love you about now
Hahaha, my specialty is making people fall in love with me. :winking_face:
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?
+9@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
+9I like you a bunch, but love - that’s a ways off. One step at a time.
lol you obviously havent spent as long as I did trying to work out the formula
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
