INDEX(MATCH formula issue

Geoff Parkins

I am trying to use helper columns to consolidate form submissions onto the top row of a sheet, in order to use Document Builder to populate a PDF with the inputs from eight different sessions. There are about 10 columns per session.

In the screenshot below, the "Which Session" column is a drop-down list with radio buttons for sessions 1-8 on the form; the "S2: Date -f" column is a text field I added as a helper column, and the "S2: Date" column is a date field, also returned from the form submission.

There will only be one entry in the "S2: Date" column, even after all eight form submissions have been collected (other than row 1). The same for the "S3: Date" column (not shown), etc, etc.

The screenshot shows how I have structured the INDEX(MATCH formula. I'm not sure why I'm getting the "NO MATCH" error.

Ultimately, what I need is all of the form responses from eight sessions copied up to row 1, so I can then trigger an automation to run the document builder.

The formula will only exist on row 1. I copied it down so I could show the formula in the screenshot.

If the formula in the screenshot is difficult to read, here is a copy/paste from the sheet:

=INDEX([S2: Date]:[S2: Date], MATCH("2", [Which Session]:[Which Session]))

Can someone help me troubleshoot this formula?

Andrée Starå

Hi @Geoff Parkins

I hope you're well and safe!

Try something like this.

=INDEX([S2: Date]:[S2: Date], MATCH(2, [Which Session]:[Which Session]))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Geoff Parkins

Thanks for the reply, @Andrée Starå It looks like that might be the ticket. Both the "S2: Date -f" and "S2: Date" columns needed to be formatted as date columns. Text input from other columns should be OK.

Thank you very much!

Andrée Starå

Hi @Geoff Parkins

I hope you're well and safe!

Try something like this.

=INDEX([S2: Date]:[S2: Date], MATCH(2, [Which Session]:[Which Session]))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Geoff Parkins

Thanks for the reply, @Andrée Starå It looks like that might be the ticket. Both the "S2: Date -f" and "S2: Date" columns needed to be formatted as date columns. Text input from other columns should be OK.

Thank you very much!

Andrée Starå

@Geoff Parkins

Excellent!

Happy to help!