Flag #CIRCULAR error

Adarian Searcy
Adarian Searcy ✭✭✭
edited 10/16/24 in Formulas and Functions

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, "")😫

Answers

  • Jennifer Kurtz
    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!

  • Hi Jennifer,

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

    Best,

    AD

  • Jennifer Kurtz
    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!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!