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

expressions
(Lindsey Allen) #1

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

(Bellave Jayaram) #2

Make sure that the type of the virtual column is Ref

(Lindsey Allen) #3

THANKS