Can a sheet summary always reference the same cell when form entries are added?

Jessica Schemrich

I am trying to create a sheet summary that pull information from a form entry. The form entries will always appear in the first row. However, even when referencing the absolute cell, when a new form entry is populated, the sheet summary field displays the previous row (now row 2). Is there anyway to always return the top row?

Andrée Starå

Hi Jessica,

Yes, it would work with the MAX function.

Would that work?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jessica Schemrich

@Andrée Starå I've shared the sheet to you. I have not used the max and collect functions before, but I'd like the med/surg summary field to always return the row 1 value.

Andrée Starå

Thanks!

I'll take a look and get back to you.

Paul Newcome

What about a basic INDEX function and specifying 1 for the row number? That would save a bit of typing as compared to a MAX/COLLECT.

=INDEX([Column Name]:[Column Name], 1)

Brad Slater

Hi, I was facing this exact problem and the INDEX formula worked perfectly. Thanks @Paul Newcome !

L_123

Yeah index( ,1) is amazing. if you have a moving target, you can use index( ,match()) in combination with a unique value in another row to return it as well.