A circular reference error occurs when one field is trying to calculate off a second field, while the second field is trying to calculate off the first. It doesn't know where to start and creates a loop that can't be completed.
In the example below, the {Name} field is referencing itself, causing a circular reference error.
<See image 1 as an example>
To uncover the circular reference, take a closer look at what other fields your formula is referencing -- it's likely referencing another formula field, which in turn is referencing (perhaps indirectly, through yet another formula field!) the original formula field (the one throwing the "circular reference" error when trying to save the formula.
The #ERROR or invalid formula error warnings point to a number of potential problems (a catch-all for any errors other than those listed in the following sections). We don't currently surface any more context on the source of the error, so you'll need to put on your best troubleshooting hat to find the source of the issue.
Some of the typical mistakes you should look for when encountering #ERROR are:
The #ERROR or invalid formula error warnings point to a number of potential problems (a catch-all for any errors other than those listed in the following sections). We don't currently surface any more context on the source of the error, so you'll need to put on your best troubleshooting hat to find the source of the issue.
Some of the typical mistakes you should look for when encountering #ERROR are:
The infinity error occurs when you divide a number by zero (which equals infinity). Since there isn't a way to represent this as a number, you'll need to adjust your formula to divide by a number other than zero.
As an example, an engineering team is working on tracking a quota of bugs addressed by each teammate. In the screenshot below, you'll see an infinity error when dividing {Completed Issues}
by {Bug Quota}
.
<See image 1 as an example>