Instead regular table, use Defined Table (Insert>Table)
Then, in case the formula will be in same table, you can refer to cell in same row, like
=[@Status] (where Status is the example name for header of referred column)
In case the formula will not be in same table, you can refer to cell of any Defined Table in same row as the current row for your formula, like
=tTest[@Status]
where tTest is the example of name of Defined Table
You also can refer to whole column of Defined Table, like
=COUNTA(tTest[Status])
Or to column header of Defined Table, like
=tTest[[#Headers];[Status]]
etc.
|