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.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!