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

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

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?

Tagged:

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 03/26/20

    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, [email protected])

    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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • @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åAndrée Starå ✭✭✭✭✭

    Thanks!

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

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • Paul NewcomePaul 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)

Sign In or Register to comment.