MIN and COLLECT formula not working
Hi all,
I am trying to return the oldest date from a date column where a checkbox is checked in another. The formula I currently have is below
=MIN(COLLECT({Change Requests Range 3}, {Change Requests Range 5}, 1))
The error I get returned is "#INVALID COLUMN VALUE".
I have screenshots below of the range details as they are referencing another sheet.
Can anyone assist with this?
Thanks,
John
Best Answer
-
Hi @John_Foster
It looks like your OriginalDate column could be a date type column. If so, the column with the formula needs to also be in a date type column as you are trying to return a date.
Hope that helps.
Answers
-
Might be worth noting here that the column OriginalDate is sometimes empty. I am not sure if this would cause an issue with this formula. But thought it worth noting.
The field is being used to identify the oldest date a row was created from a form, but as we have migrated data over from an older system I wanted a way to identify the original date and not the date the row was created.
-
Hi @John_Foster
It looks like your OriginalDate column could be a date type column. If so, the column with the formula needs to also be in a date type column as you are trying to return a date.
Hope that helps.
-
Thanks @KPH , this was the issue. All is working now.
-
Great news!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
