Column Formula to return 1st, 2nd, 3rd, etc. instance of a column entry.

I am looking for a Column Formula that will return the 1st, 2nd, 3rd instance of a column entry.

The following cell formula works, but I am not able to make this into a column formula and need it to be a column formula so that when our form users submit a new form the Delivery Count column automatically updates. This is my cell formula =IF([Task Name]@row > "", COUNTIF([Task Name]$1:[Task Name]1, [Task Name]@row), "")

Any help would be greatly appreciated!

Thank you!

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try inserting an auto-number column (with no special formatting) and then use something like this:

=IF([Task Name]@row <> "", COUNTIFS([Task Name]:[Task Name], @cell = [Task Name]@row, [Auto-Number]:[Auto-Number], @cell <= [Auto-Number]@row))

KelliBretsch

This worked perfectly, thank you so much!!

Paul Newcome

Happy to help. 👍️

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.