View Single Post
 
Old 09-15-2025, 08:01 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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.
Reply With Quote