I am trying to create a virtual column that r...

I am trying to create a virtual column that returns the date of the most recent entry in a related sheet.

App formula: MAX(SELECT(NOTES[DATESTAMP],[CUSTNO]=[_THISROW].[CUSTNO]))

I keep running into this error: The expression is valid but its result type ‘Ref’ is not one of the expected types: List

Can anyone help?

Thanks

0 2 349
2 REPLIES 2

Make sure that the type of the virtual column is Ref

THANKS

Top Labels in this Space