I have columns A B C D and I’d like to count each cell from those columns in 1 row that are TRUE, and output the total number as text or rich text or number entry
So if cell in column A B C is true then the output shows 3 as text
How can I do this? 
Are these boolean columns, or are they Text columns containing the word TRUE?
If boolean columns, you can use a Rollup column, counting true values.
If text columns, use a query column and filter where the column is TRUE, and then use a rollup on the query.
Update: oh, wait - these are 4 separate columns?
hmm, okay. In that case the easiest thing would be to make them boolean columns (if they aren’t already), and then use a Make Array column to create an array from the 4. You can then do a rollup on the array.
1 Like
Hi there, so they are each boolean columns, and separate columns. And if using the Make Array Column, how would you go about doing this rollup on the array?
Thank you for your help!
First you need to add each boolean column into the Make array column. The add a Rollup column and point it at your make array column. That should be it.
3 Likes