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
Make sure that the type of the virtual column is Ref
THANKS
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |