Import Formulas

When matching imported data to transaction properties, there's an option to enable a Formula that will transform the value from the CSV cell.

The relevant variables and functions are:

  • value - cell's value

  • index - current row index

  • col(columnName[, index]) - reads value from another column (and possibly another row)