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 |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |