Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
On a list box I only want to show the Field values that have another field value associated to them.
Table A | Table B | |||
ID | Name | Name | Input | |
1 | A | A | Yes | |
2 | B | B | No | |
3 | C | C | ||
4 | D | D |
For Example from the above tables I create a list box in a Sheet with ID and Name, I only want it to display those IDs that have a value in Input field in table B
write an expression in the list box instead of column . Assuming that Table A and B are associated with Name column.
if(len(input)>0, ID)
write an expression in the list box instead of column . Assuming that Table A and B are associated with Name column.
if(len(input)>0, ID)
Hi
like Eddie Morah but other expression
=if(Input <> '',ID)
Best,
Alessandro Furtado
but thinking better it depends about your data. Like Eddie Morah will works everytime (using len).....
Alessandro Furtado
Thanks guys was very helpful