Help w/ Date formula

I am trying to make a formula that inserts the date when a selection is made in a drop down cell in another sheet. For instance, the user selects "IIMC / INSTRUMENT" in the training drop down. I want the date it was selected to fill into the other sheet.

Dropdown.

I want the date to go into this cell on a separate sheet.

Here is the formula I have, but I am getting an unparseable error:

=IF({TRAINING} = "IIMC / INSTRUMENT", {PILOT}PILOT@row, {DATE}, =TODAY())

Find more posts tagged with

Accepted answers

Paul Newcome

You have misplaced parenthesis and need to finish out the "logical statement" portion of the IF.

=IF(INDEX(..., MATCH(...)) = 1, INDEX(..., MATCH(...)))

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.