Help simplifying conditional column

[Borjaveigasvh]

Good Afternoon, 

Maybe someone has a tip for this kind of calculated column.

My table has 6 columns with diferent values for each row. not all columns have values, in order to determine how many columns have value in each row an qualify the completness of each row, I was thinking on creating a conditional column. but combinations are very high and that would give me a very long conditional formula.

I would like to see  if a row has 1, 2, 3, 4, 5 or 6 columns with value 

First one is easy because I only have to write it with an OR bolean, 6 is also easy bacause I just need to write the bolean And but the rest is a nightmare. 

Any solutition that makes it simplier? 

Thanks Community!!

[lbendlin · Accepted solution]

You can abuse the logical true as a number.

Calculated column= sum(column1>blank + column2 >blank + ...)

Might need additional encapsulation.

[Borjaveigasvh]

True! Thanks I din't see it that way.

Many thanks 

Borja