How to reference a column from another table

[YIK3S]

I'm writing a formula that uses a column from another table but I am unsure how to refer to/call it. please advise on how to do so. I have tried using select and ref rows but I keep getting an unknown error.

[Steve]

Please post screenshots of the error and of the expressions you've tried.

[YIK3S]

Arithmetic expression '(TODAY()+SELECT(Cylinder_Info[_RowNumber],([AGE] = [_THISROW])))' has inputs of an invalid type 'Unknown'

[Steve]

SELECT() returns a list, not a singular value. Wrap SELECT() with ANY().

https://help.appsheet.com/en/articles/2347632-any

[YIK3S]

Column Name 'Cast Date' in Schema 'Set_Info_Schema' of Column Type 'Date' has an invalid Initial Value of '=TODAY()+REF_ROWS("Cylinder_Info", "AGE")'. Arithmetic expression '(TODAY()+SELECT(Cylinder_Info[_RowNumber],([AGE] = [_THISROW])))' has inputs of an invalid type 'Unknown'