When working with formulas in your model sheets in Adaptive Planning you may come across an oblique error which doesn’t initially appear to make sense, but once you understand what it is, it becomes fairly obvious what it means (like most errors!).
So what is the error and how do you fix it?
Have you been writing an
if statement or two in your formula?
The reason for the error is that it relates to an
if function used in your formula. You need to make sure the structure of your
if formula statements contain a truth-y capture, and a false-y capture.
if ( 2 > 1, 3, 0 )
In the above
if formula, we have a capture of the statement first, which asks: is 2 is greater than 1 (
2 > 1)?
If the statement is true then we return the first capture in our if statement structure, being
3. If the statement is false then we return the second part of our if statement, being
So look at your
if statement in your model and check the following:
- Is there a
falsesection to the
- If there are nested
ifstatements check the brackets are in the right areas.
Simple examples of where I’ve encountered the error in my own model sheets:
- I’ve removed a function within the statement part of the
iffunction and have forgotten to remove all the brackets from within that section, or perhaps I did not have enough brackets:
if ( 2 > 1 ) 3, 0 )
- The other times I have made this mistake is when I go a bit crazy on nested if functions and forget one of the outer
ifstatements didn’t have its false-y value.
if ( 2 > 1, if ( 3 = 0, 1, 2 ) )
If you come from an Excel or spreadsheet background these errors should be relatively easy to spot. If you are more familiar with a programming language writing
if statements like this can be a bit of hassle.
If you’re coming from another language just remember the
if statement is a function and requires 3 parameters.
In Microsoft Word you can control whether or not you want to see the white space characters in your document. This helps to check you haven't incorrectly inserted a tab where a space should have gone...
Very similar to our previous article on how to make a header row in Google Sheets, in this article we'll show how you can lock a column in Google Sheets. To lock a column in Google Sheets easily...