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
User | Count |
---|---|
43 | |
29 | |
25 | |
23 | |
13 |