Forum Discussion

Borjaveigasvh's avatar
Borjaveigasvh
Regular Visitor
6 years ago
Solved

Help simplifying conditional column

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!!

 

  • You can abuse the logical true as a number.

     

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

     

    Might need additional encapsulation.

2 Replies

  • You can abuse the logical true as a number.

     

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

     

    Might need additional encapsulation.

    • Borjaveigasvh's avatar
      Borjaveigasvh
      Regular Visitor

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

       

      Many thanks 

      Borja