I want to use a row sum in another table in a special cell. How is the syntax for the formula?
I know it can be realised by a link but I don’t want to insert all links from all rows, because the number of rows can be changed!
thanks for helping
I want to use a row sum in another table in a special cell. How is the syntax for the formula?
I know it can be realised by a link but I don’t want to insert all links from all rows, because the number of rows can be changed!
thanks for helping
You simply describe the path to the column in the associated table. In other words, the formula has this syntax: {LINK_COLUMN_IN_THE_CURRENT_TABLE.TARGET_COLUMN_IN_ASSOCIATED_TABLE}
In the screenshot below, devices (monitors, projectors, …) are allocated to rooms. The column “Devices” shows the number(s) of the devices in that room. If I want to show the type of device behind that number, the formula is {Devices.Type}. “Type” is the name of the column in the associated table.
And this is the result:
Do it like thousands of other people who have used SeaTable to develop powerful processes and get their ideas and tasks done more efficiently.