Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello !
All i want to do is to check if there is a value called 'B' in a FIELD2 at the row 'A' in FIELD1
I've tried:
=if(match('A' , { $ <FIELD1= {'B'}>} FIELD2 ),1,0)
=if(match('A' , FIELD1 ),1,0)
don't works either
I've also tried
=if(FieldValue('FIELD1 ',fieldIndex('FIELD2 ', 'A'))='B',1,0)
But it doesnt works because there is a lot of duplicate values in FIELD1
Thanks in advance for your answering,
Regards
Perhaps this?
If(FIELD1='A', If(FIELD2='B', 1,0))
Perhaps this?
If(FIELD1='A', If(FIELD2='B', 1,0))
thanks a lot !