Sheet to reference last record from a form

Markus1998

I have seen numerous answers to this question, but I am still confused about the syntax. e.g https://community.smartsheet.com/discussion/20126/report-with-the-last-entry-to-each-persons-forms

I have an Smartsheet form (Input form) that collects the PSHC, peak shift head count.

I have a separate sheet that needs to reference the last record in the input form. When I try to use the formula suggested by the link above, I get an unparseable error. I hope it's simply a syntax error on my part.

MAX(COLLECT([Created]:[Created], [PSHC]:[PSHC], =[PSHC]@row)), 1, 0)

I originally tried a simple reference to the entire PSHC column, but it only linked to the first record, not the latest one.

Please advise,

Thank you!

Find more posts tagged with

Accepted answers

All comments

Christian G.

Have you miss this part of the formula : IF([Created]@row= MAX(COLLECT(Created:Created, [Assigned To]:[Assigned To], =[Assigned To]@row)), 1, 0) ?

Markus1998

Sorry, I am confused.

Am I supposed to use this formula instead?

=IF([Created]@row= MAX(COLLECT(Created:Created, [PSHC]:[PSHC], =[PSHC]@row)), 1, 0)

I tried using this formula, but it still shows #UNPARSEABLE

Markus1998

Thanks Christian for your help. Although I could not get it to work, I still appreciate your response.

I think I found my answer here thanks to Jeff Reisman: https://community.smartsheet.com/discussion/87252/simply-retrieving-last-row-referenced-in-another-sheet?_gl=1*15m8gsp*_ga*NTkwMTkxNzIxLjE2NjQ0NjczOTQ.*_ga_ZYH7XNXMZK*MTY2NjI4MzU3OC4zMi4xLjE2NjYyOTY1ODkuNC4wLjA.

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.