Hi,
I was trying to focus on preventing errors by added a list of very specific dates one can submit requests. I was hoping to have a drop down of dates to choose from. Then I have additional columns that will match that date selected and autofill the rest of the due dates from another sheet.
If the user inputs the date manually, I have a formula that pulls the next column. That formula is:
=INDEX({2025 Dates | AELR Due Dates}, MATCH([Publication | Issue Date]@row , {2025 DSD DATES | Regulation Issue Date 2}, 0))
The drop down column I am test is not a date column, so I am aware that causes some issues. I attempted to add quotations at the end since another user helped me with that previous but it is not working in this instance and AI is not figuring it out for me either. Probably a me issue.
Does anyone know if it is possible to match a date from a drop down column?