Mark an old submission

Hi,

I have a sheet I created where a name and status are being inputted through a Smarthseet form. I am trying to figure out a formula to mark old submissions.

Meaning if someone submits a name with the status of "Onboarding" and then submits the form again with the status "Hired", what formula can I use to mark the old submission?

I'm not sure if the Modified/Created Date option will work because sometimes a submission can happen within the same day or even the same hour.

I was playing around with duplicate and a MIN formula based on Row ID, but couldn't figure it out.

Thanks for the help!

Find more posts tagged with

Formulas

Automations

Cell linking

Accepted answers

Paul Newcome

Insert an auto-number column with no special formatting. Then you can use a formula such as

=IF(COUNTIFS(Name:Name, @cell = Name@row, [Auto-Number]:[Auto-Number], @cell> [Auto-Number]@row)> 0, 1)

All comments

Paul Newcome

Insert an auto-number column with no special formatting. Then you can use a formula such as

=IF(COUNTIFS(Name:Name, @cell = Name@row, [Auto-Number]:[Auto-Number], @cell> [Auto-Number]@row)> 0, 1)

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.