INDEX/MATCH Dates is returning #DATE EXPECTED
Hello! I am having trouble with the formula below. I am trying to run a compliance check and need to confirm if the clinics are completing their monthly assignments.
The clinics column is the primary list of all clinics at our organization and the reference column has an index/match formula pulling from another sheet to associate if the clinic actually completed their assignment. I am also trying to associate and match the date of the completed assignment, but I am getting an error for #DATE EXPECTED. I've already turned the column into a Date type so I am not sure why I am getting this message... See formula I was using below. Thank you in advance for guidance and assistance!
=IFERROR(INDEX({Ambulatory Manager's Continuous Readiness Range 2}, MATCH(Clinics@row, {Ambulatory Manager's Continuous Readiness Range 2}, 0)), "")
Answers
-
Hi @Jcuison,
Is this range a date range: {Ambulatory Manager's Continuous Readiness Range 2}?
If not, revise the reference in your formula immediately following the INDEX to reference a date range from your referenced sheet.
INDEX( DATE RANGE , MATCH(etc...
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
Yes the following is a date range: {Ambulatory Manager's Continuous Readiness Range 2}.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!