Use the IF function with multiple conditions without having to use
more than two parentheses. Use SWITCH when you need to test the
same value for equality against other values.
CSV files produced by report buttons can now be customized to make
them compatible with more apps and services. Change the decimal
separator and the delimiter separating values and lay out values
vertically instead of horizontally.
If a function isn't returning the value you expect, you need to
look at the parameters it receives by creating new temporary fields
visualizing the parameters. To do so with an array, you need to
convert it to a text string first using the TEXTJOIN function.
Ranges are an effective means of creating arrays containing many
elements. However, it is easy to lose track of what elements they
contain, which can have surprising results. This tip explores this
topic in depth.
We work hard to ensure that your apps continue working, even as we
add features to Calcapp. With our new formula engine, we have made
some minor changes, but they should not affect your existing apps.