How do I use the calculate a new column filter?

If you need to create a column using data from an existing column, you can use the Add Cell Filter > Split, Merge & Transpose > Calculate a New Column filter:

In order to cite a column you wish to work with, you can use the default 'Col #'. This filter is flexible and supports all basic math operations, addition (+), subtraction (-), multiplication (*), and division (/), and supports order of operations by using parenthesis in your calculation:

example one

example two

If you have any questions or run into trouble getting set up please reach out to us at

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us