Flag #CIRCULAR error

Adarian Searcy

Hi,

I am attempting to create a formula that will check the At Risk (Flu) if it meets certain criteria.

If Flu Compliance Status is "Non-compliant" and Level of Flu is grater than 5% check At Risk (Flu).

The formula I created with a #CIRCULAR error is listed below.

=IF(AND([Flu Compliance Status]@row = "Non-compliant", VALUE([Level of Flu]@row) > 5), [At Risk (Flu)]@row, "")😫

Find more posts tagged with

Accepted answers

All comments

Jennifer Kurtz

Hey there! You don't need to reference the column where you're putting the formula in the "value if true" part of the formula - i.e., [At Risk (Flu)]

I think that's why you're getting the circular error.

Hope that helps!

Adarian Searcy

Hi Jennifer,

Thanks for the assistance. Now I have a #UNPARSEABLE error. I will continue to work on it.

Best,

Jennifer Kurtz

I suspect the UNPARSEABLE is related to the VALUE function with the "Level of Flu" column. Is that a drop down column? I think you'll need to use a different statement there. If it's a drop down, something like [Level of Flu]@row= "<6% to >9%"

(Also, is that range option possibly supposed to be greater than 6% to less than 9%? >6% to <9%?)

Good luck!

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.