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.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives