Pulling most recent values from form submission

Hi Community,

I'm attempting to pull a value from a cell based on the most recent form submission.

The information I'm trying to pull is from the below:

I'm looking for a formula to collect the value from from the "Visually Inspect ARU1 HMI/ verify systems in auto" column based on the most recent submission (Row 1).

I've attempted a max(collect) function but I can't seem to piece it together.

Any help would be appreciated!

Thanks

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

=INDEX([Visually Inspect ARU1 HMI/ verify systems in auto]:[Visually Inspect ARU1 HMI/ verify systems in auto], 1)

All comments

Paul Newcome

Try this:

=INDEX([Visually Inspect ARU1 HMI/ verify systems in auto]:[Visually Inspect ARU1 HMI/ verify systems in auto], 1)

Bryan Letourneau

Ahh the previous posts I saw in the community advised using the max collect function, this worked perfectly!

Thanks Paul!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.