MAX(COLLECT Not Returning Anything
Hi! I'm running into an issue using MAX and COLLECT that I was hoping someone in community could help out with.
I've got a sheet that collects billing information. Among other things, a sheet for each employee contains a Project ID and a Monthly Report End Date.
Each month, new rows are added to the sheet. As projects tend to take longer than one month, we can generally expect multiple rows will have the same Project ID. We'd like to include a column that indicates, for each project, the last Monthly Report End Date.
The Project ID column is a Text/Number column. The Monthly Report End Date column is a Date column. The Latest Bill Date column is a Date column, but it is not restricted to dates.
The formula we are using is copied below:
=MAX(COLLECT([Monthly Report End Date]:[Monthly Report End Date], [Project ID]:[Project ID], [Project ID]@row))
For some reason, that doesn't return anything. If I turn both the Monthly Report End Date column and the Latest Bill Date column to Text/Number columns, it returns "0". Any assistance you could provide would be greatly appreciated!
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!