=ISNUMBER

Hi!

I am trying to figure out the proper way to incorporate =ISNUMBER into my formula. I keep getting errors and can't figure out how quite to frame it in. I have a flag but I do not want it to flag blanks or text. I only want to flag duplicate numbers.

=IF(COUNTIFS([Site ID]:[Site ID], [Site ID]@row) + COUNTIFS([Device ID]:[Device ID], [Site ID]@row) + COUNTIFS([License ID]:[License ID], [Site ID]@row) > 1, 1)

Find more posts tagged with

Accepted answers

Paul Newcome

My apologies. I must have missed that update.

=IF(ISNUMBER([Site ID]@row), IF(COUNTIFS([Site ID]:[Site ID], [Site ID]@row) + COUNTIFS([Device ID]:[Device ID], [Site ID]@row) + COUNTIFS([License ID]:[License ID], [Site ID]@row) > 1, 1))

Paul Newcome

Happy to help. 👍️

All comments

Paul Newcome

Try this:

=IF([Site ID]@row <> "", IF(COUNTIFS([Site ID]:[Site ID], [Site ID]@row) + COUNTIFS([Device ID]:[Device ID], [Site ID]@row) + COUNTIFS([License ID]:[License ID], [Site ID]@row) > 1, 1))

Meagan80

Hi Paul,

That works for blanks but I also do not want it to flag if there is text in the field. Only numbers.

Thank you!

Paul Newcome

My apologies. I must have missed that update.

=IF(ISNUMBER([Site ID]@row), IF(COUNTIFS([Site ID]:[Site ID], [Site ID]@row) + COUNTIFS([Device ID]:[Device ID], [Site ID]@row) + COUNTIFS([License ID]:[License ID], [Site ID]@row) > 1, 1))

Meagan80

That worked! Thank you!!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.