Help w/ Date formula

Paul Newcome

I meant withing the actual MATCH function.

=INDEX(.........., MATCH(....., ....., 0))

That last zero is missing from your first INDEX/MATCH. That's the only thing that needed added.

I'm on mobile at the moment, so I can't bold text. Let me know if this doesn't make sense, and I'll make another update once I get back to my computer.

BMiller828

I think I copy. Like this.

=IF(INDEX({TRAINING}, MATCH("FLIGHT REVIEW", {TRAINING}, 0)) = 1, INDEX({DATE}, MATCH(PILOT@row, {PILOT}, 0)))

Still getting a blank cell.

Paul Newcome

I must have missed something... I thought we were looking for a checkbox?

BMiller828

I am. The box is called "Flight Review". The checkboxes are located in a column titled training on another sheet. When that box is checked on the form / sheet, I want the date to populate into this cell in the column titled "flight review" on my master sheet. There are multiple boxes that could be checked with different names. I have a columns matching those names on the master sheet so I can track what date the task was completed / box checked.

Paul Newcome

Are you able to provide screenshots of those checkboxes?

BMiller828

When user submits a form, they check one or multiple boxes on this sheet.

I then need the date to populate into these boxes on the master sheet. Ignore the data that is there as its not accurate. As you can see, I have the formula in the FLIGHT REVIEW column. Its returning a blank cell.

Paul Newcome

Ah. Ok. So you are using a multi-select dropdown column. I was thinking it was a series of checkbox columns. Ok. We need to change it up a bit. What does this do?

=IFERROR(INDEX(COLLECT({DATE}, {Training}, HAS(@cell, "FLIGHT REVIEW"), {PILOT}, @cell = PILOT@row), 1), "")

BMiller828

Paul, worked instantly. I am sure I was asking the wrong questions. Thanks for all your help!

Paul Newcome

Happy to help. 👍️