How to setup a form for multiple entries that update the same row

Martin_M

Hello,

We're trying to create a form that you would use throughout the day checking boxes as certain daily tasks get completed.

Goal is, to have 1 row per day.

In that row you have an X amount of columns, each represents a task. Those tasks - for now - I have as separate form-fields (checkbox) in the form.

Example:

Entry date 4/18/2023

[] 8:00-8:45 - "Task 1"

[] 8:45-9:30 - "Task 2"

[] 9:30-10:15 - "Task 3"

...

Once you complete "Task 1", you check the box and submit. When "Task 2" is completed, you again would check that box in the form and submit, and so on... Each time one of the boxes per completed task gets checked, the SAME ROW in the sheets gets updated with that new entry.

How would I do that? Is that possible? What steps would I need to do to make that happen?

As of now, each time the form is submitted, the entries "arrive" in the sheet in a new row.

Thank you very much in advance for any help!!

Ryan Sides

Hi Martin, you’ll need two sheets to make this happen. The first sheet with the form is collecting the entries throughout the day.

The second sheet lists all of the dates and has cross sheet formulas to look back at the first sheet to see which tasks were completed.

You’ll use index /match formula on the second sheet to pull that data in.

Does that help point you in the right direction?

Martin_M

Hi Ryan,

THANK YOU for this unexpectedly quick response!!

I will try to find out how to get this done and how to use the index/match formula.

Ryan Sides

You’re welcome! Let me know if you run into any issues.