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:
If you have any questions or run into trouble getting set up please reach out to us at firstname.lastname@example.org.