Recently broken formulas If(CountIF to find duplicate values

For several months I have succesfully used the following formula to identify duplicates values in the Program ID column.

=IF(COUNTIF([Program ID]:[Program ID], [Program ID]@row) > 1, "Duplicate", "Unique")

Program ID is a formula generated column using the following formula.

=[Site Num]@row + "." + ProgNum@row

A recent Smartsheet update has broken this formula. As you can see, 22.01 should throw a duplicate value but it does not.

Find more posts tagged with

Accepted answers

Victoria_Indimar

@nbers I'm not exactly sure why but it looks like your formula is just missing an "=" for your COUNTIF criteria. I bolded below. Please try this and see if that helps resolve!

=IF(COUNTIF([Program ID]:[Program ID], =[Program ID]@row) > 1, "Duplicate", "Unique")

All comments

Victoria_Indimar

@nbers I'm not exactly sure why but it looks like your formula is just missing an "=" for your COUNTIF criteria. I bolded below. Please try this and see if that helps resolve!

=IF(COUNTIF([Program ID]:[Program ID], =[Program ID]@row) > 1, "Duplicate", "Unique")

nbers

Thank you - that did indeed work. Do you know if this is recent change to formula writing in Smartsheet? Prior guidance from Smartsheet experts (like here) excludes the extra = sign and even the (albeit not very good) AI formula generator within smartsheet leaves out that extra = sign.

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.