INDEX and MAX gets Invalid data type match
I have the reference to the MAX working correctly and pulls the newest date, but when I add it to the index to pull the information from the text field in the associate sheet I get invalid data type. Am I missing something? Can you advise?
=INDEX({Display by Tech Range 2}, MAX({Display by Tech Range 1}), 0)
Display by Tech Range 2 is text/number
Display by Tech Range 1 is create date
The display column is text/number. The goal is to do a compare and set a yes/no check box for establishing a user specified report filter.
Best Answer
-
There are a couple of issues...
You indicated the MAX function is pulling a date, but you have it in a position within the INDEX function that requires a numerical value. You also have 0 set as the column number to pull from. There is no column 0. At the very least you would need to change this to a 1.
Try this instead...
=INDEX({Display by Tech Range 2}, MATCH(MAX({Display by Tech Range 1}), {Display by Tech Range 1}, 0))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
There are a couple of issues...
You indicated the MAX function is pulling a date, but you have it in a position within the INDEX function that requires a numerical value. You also have 0 set as the column number to pull from. There is no column 0. At the very least you would need to change this to a 1.
Try this instead...
=INDEX({Display by Tech Range 2}, MATCH(MAX({Display by Tech Range 1}), {Display by Tech Range 1}, 0))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!