Hello there!
I have a table, where I need to create a smart filter (Valid If and Show If) in several columns, with a specific initial value (“Mes completo”) this value will be added or take it away if the sum of the values (numeric) of certain columns are equal to IF(AND([Preg6]=“S”,[Preg7]=“S”,[Preg8]=“S”,[Preg9]=“S”,[Preg10]=“S”),“Mes completo”,true). This expression is repited in several columns regarding the values of other columns. What I need is only allowed 1 value (“Mes completo”) in the hole form, and is this value can be repited in other columns show an error or not allow to save the form, beacause it must be only 1 (“Mes completo”).
I create a virtual column that controls the text values (“Mes completo”) of all the table and converted them into a number 1, so if there is any more than 1 (“Mes completo”) must shows an error in the columns where the value text is equal to (“Mes completo”).
[Mes_completo_notblank_expression]:
IFS(
[Un mes2]=“Mes completo”,1,
[Dos meses2]=“Mes completo”,1,
[Tres meses2]=“Mes completo”,1,
[Cuatro meses2]=“Mes completo”,1,
[Cinco meses2]=“Mes completo”,1,
[Seis meses2]=“Mes completo”,1,
[Siete meses2]=“Mes completo”,1,
[Ocho meses2]=“Mes completo”,1,
[Nueve meses2]=“Mes completo”,1,
[Diez meses2]=“Mes completo”,1,
[Doce meses2]=“Mes completo”,1,
[Quince meses2]=“Mes completo”,1,
[Dieciocho meses2]=“Mes completo”,1,
[Veintiún meses2]=“Mes completo”,1,
[Veinticuatro meses2]=“Mes completo”,1,
,true,0)
Then I create a second virtual column that SUM´s the number values of the expresion:
[Mes_completo_count]: SUM([Mes_completo_notblank_expression]) this is not summing [Mes_completo_notblank_expression]
And the filter condition in the columns that must enter or take away automaticaly the text value (“Mes completo”) has this expression:
Valid if: [Mes_completo_count]<2
Show if: [Mes_completo_count]<2
But all of this is not working, beacause SUM([Mes_completo_notblank_expression]) is not summing
Any ideas?
LinkedIn
Twitter
