Extract column from RefRows


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

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))

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.

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.

1 Like

Thank you! @Steve

1 Like