Hello,
Is there a difference between Table[Column] and Table.[Column] when trying to reference values from other tables?
If so, how do you use each case.
Is one a column list expression and the other is not? (See snipped from Appsheet documentation below)?
from-dataset-column
: The specification of the table or slice (the โdata setโ) to search and the column from which values are to be gathered, in the form: dataset-name
[column-name]
. For example, Orders[Order ID]
. Although identical in appearance to a column list expression, this argument is not an expression.User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |