Circular Field Reference Error
When i modify Recalculation setting as 'Always' in a calculated Values list field, i am getting Circular Field Reference error popup. But i am not getting the actual path which causes the circular reference. I tried to give Validate in a formula builder, still i am not getting the actual circular path. We are using Archer 6.3 P3. Please help me to resolve the issue.
Thanks in advance for your response.
It is throwing the same error whatever the clac formula is. The reference formula is also getting the same error. If the error path is displayed, it will be easy to find the root cause and solution.
Overall Status (Prior) - [Overall Status]
Overall Status - Will calculated the status of the record
Overall Status Comparison - IF( ISEMPTY( [Overall Status]), ValueOf( [Overall Status Comparison], "Status Has Not Changed"), IF( [Overall Status (Prior)] = [Overall Status], ValueOf( [Overall Status Comparison], "Status Has Not Changed"), ValueOf( [Overall Status Comparison], "Status Has Changed")))
Question 001 - IF( AND(CONTAINS(ANY,[Overall Status],VALUEOF([Overall Status],"Approved","Awaiting Review")),NOT(ISEMPTY([Edit Question 001]))),[Edit Question 001],
IF( OR ( [Overall Status] = "Approved", [Overall Status]="Rejected"), [Question 001],
I am not able to update Overall Status Prior field to 'Always'. These fields are in a questionnaire, we have referenced questionnaire overall status in some of the calc fields in target application too.
This is a shot in the dark, but it would appear the circular reference chain is between Overall Status and Question 001. Since, I'm assuming, Question 001 depends on the value of Overall Status and Overall Status depends on the value of Question 001 you're caught in a loop. I recommend not using Overall Status in the Question 001 calc to see if this fixes the problem.