Formula Playground
Copy base
Report abuse
Views
Name
1
NaN
2
Circular reference
3
Invalid formula
4
#ERROR
5
Infinity
Drag to adjust the number of frozen columns
Description and troubleshooting
Attachments
Support article link

Standing for not a number, the NaN error appears when you attempt to divide zero by zero. To fix the error, the most simple approach is to run a valid formula that results in a definable number (e.g. anything but 0 / 0). However, you may want to conditionally run a different calculation for instances when two fields both have a zero value. 


For example, if you're tracking progress towards a goal. You would use the formula {Actual} / {Goal} to display progress towards that goal as a percent. However, because formulas apply to every record in a table, NaN shows for any records where there are zero values in both fields.


<See image 1 as an example>


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:

  • Mis-typed or non-existent field names, or mistyped functions
  • Missing {curly brackets} around field references
  • Missing or misplaced (parenthesis) around separate functions in your 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:

  • Mis-typed or non-existent field names, or mistyped functions
  • Missing {curly brackets} around field references
  • Missing or misplaced (parenthesis) around separate functions in your formula

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>



5 records
  • Common Errors
  • Gallery of Errors
Extensions

Alert

Lorem ipsum
Okay