Writing Formula for Sheet Summary Field

Based on the screenshot below, I am trying to write a formula that will pull in the reason for change on the row where " most recent change" is checked. Thoughts on the best formula?

I've tried:

=IF([Most Recent Change]:[Most Recent Change] = 1, [Reason for Change]:[Reason for Change] , "")

Is there something I can do with @cell?

Thanks!

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

DKazatsky2

Hi @Smar Czar,

Give this a try.

=IFERROR(INDEX(COLLECT([Reason For Change]:[Reason For Change], [Most Recent Change]:[Most Recent Change], 1), 1), "")

Hope this helps,

Dave

All comments

DKazatsky2

Hi @Smar Czar,

Give this a try.

=IFERROR(INDEX(COLLECT([Reason For Change]:[Reason For Change], [Most Recent Change]:[Most Recent Change], 1), 1), "")

Hope this helps,

Dave

Smar Czar

Thank you @DKazatsky2. This worked! Thank you

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.