Automatic Status (Green, Red, Yellow) depending of two Colum condition
Hi everyone!
I'm trying to configure a Health Status condition depending on two colum statuses here the formula "=IF([Health Status]@row = "Not Started", "", IF(AND([Due Date]@row < TODAY(), [Health Status]@row = "In Progress"), "Green", IF([Due Date]@row >= TODAY(), IF([Health Status]@row = "In Progress", "Red", "Green"), IF([Health Status]@row = "Complete", "Green", "Yellow"))))"
Its return a #CIRCULAR REFERENCE message
Can anyone help to find a solution?
Regards
Wilfredo Caban
Answers
-
You are probably either putting this formula into the [Health Status] column, or the [Health Status] or the [Due Date] column have a reference (probably formula) that's referencing back to the column you're trying to build this formula into. Here's a description of a Circular Reference error:
#CIRCULAR REFERENCE
Cause
The formula references itself. The circular reference may be direct where the reference is in the formula text itself, or indirect where this formula references a cell which then references back to this cell.
Resolution
Determine which reference is circular. Indirect references can be many levels deep. Sometimes it is easiest to make a copy of the formula and remove cell references until the error is eliminated. This process of elimination will help you see which reference is ultimately circular.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!