I keep getting an error when I use the collect function. I'm trying to return the most future date in a column of dates. There are no blanks, all rows are populated. I've checked and all rows are dates.
COLUMNS:
* Line Item Renewal Date = date
* Application Name = Text
=MAX(COLLECT([Line Item Renewal Date]:[Line Item Renewal Date], [Application Name]:[Application Name], [Application Name]@row))
—> #INVALID COLUMN VALUE
——→ This is the only one where the formula has the colors that indicate the tool recognizes it as a formula.
=MAX(COLLECT({Line Item Renewal Date}, {Application Name}, [Application Name]@row))
—> #INVALID REF
=MAX(COLLECT([Line Item Renewal Date], [Application Name], [Application Name]@row))
—> #UNPARSEABLE
So. What am I doing wrong here? I've seen variations of how to enter this and I cannot crack this.
