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?