This formula is in suggested values : sort(select(Input[block],[company]=[_THISROW].[company])).
This formula does not produce a dropdown list with only the blocks equal to [_thisrow].[company].
It produces a dropdown list of all blocks from input[block].
How to make a dropdown list of Input[block] containing only the blocks equal to [_thisrow].[company] and also can add/edit values?
Users must see only a selected list from table Input and be able to add new blocks.
LinkedIn
Twitter
