Extract column from RefRows

[badm]

Hello,

Is it possible to extract a single column from refrows. I will perform calculations on the “extracted column” and display result in parent record.

[Steve]

If by “refrows”, you mean a column with an App formula expression that uses REF_ROWS(), you’ll need to use SELECT() to get the specific row and column, then ANY() to convert the List result to a singular value:

ANY(SELECT([Related somethings][wanted-column], match-expr))

[badm]

To clarify, the inline table has a duration column. My goal would be to access that column. Yes, I using Ref_Rows to display the inline table.

[Steve · Accepted solution]

You could even do:

SUM([Related somethings][Duration])

to sum the contents of the Duration column of the rows identified by the Related somethings column.

[badm]

Steve:

SUM([Related somethings][Duration])

Thank you! @Steve