Hi
I am trying to create a drop-down column in Table C from table B based on an answer from table A. For Instance
Table A is my customer list
Table B is my Job List
Table C is my Commissioning App
In Table C I select the customer based on results from Table A (Which works fine). I then have a column called job number in Table B and a column called Job Number in Table C, I want Job Number in Table C to have a drop down with job Numbers that have the same customer Name.
I hope this makes sense
Thanks
Blake
Try:
IFS(
ISNOTBLANK([Customer]),
SELECT(
Table B[Job Number],
([_THISROW].[Customer] = [Customer]),
TRUE
)
)
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |