Column formula - for increasing same value in array

Hi, I would like to see if it is possible to change the below FirstInstance formula into a column formula as I am using Data Shuttle to import new/revised data into the grid.

FirstInstance Formula: =COUNTIF([Request Id]$1:[Request Id]1, [Request Id]1 = [Request Id]@row) + 0

DaystoClose2 col Formula: =IF(FirstInstance@row = 1, [Status Date]@row - [Request Date]@row)

Find more posts tagged with

Accepted answers

Mark Cronk

Hi,

Try adding an autonumbering column. Use it to determine the newest entry using the formula:

=IF([Auto Num]@row=MIN(COLLECT([Auto Num]:[auto num], [request ID]:[request ID], [request ID]@row)), 1, 0)

The 1st instance will have the lowest autonumber and will return a 1 in the first instance column.

Work?

Mark

All comments

Mark Cronk

Hi,

Try adding an autonumbering column. Use it to determine the newest entry using the formula:

=IF([Auto Num]@row=MIN(COLLECT([Auto Num]:[auto num], [request ID]:[request ID], [request ID]@row)), 1, 0)

The 1st instance will have the lowest autonumber and will return a 1 in the first instance column.

Work?

Mark

Paul Westerink

Mark,

Thank you! That worked perfectly.

Paul

Mark Cronk

Excellent. Glad you found a solution. Thank you for contributing to the Community.

Mark

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.