Errors when using Collect function
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.
Best Answer
-
Hey @David Hinman
What column type is the column where your Max/Collect formula sits? It also needs to be a date type column since the data you are collecting is a Date.
Kelly
Answers
-
Hey @David Hinman
What column type is the column where your Max/Collect formula sits? It also needs to be a date type column since the data you are collecting is a Date.
Kelly
-
You've got to be kidding me. That was it? I guess I'm used to Excel which would return a value as a number and I'd use the formatting to convert to a Date. Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives