How to create a FX Column

Stwillis

I am using the template Invoice Receiving & Routing Management to create a new tracker. The first column is an FX column but this column isn't referenced in the sheet summary. How do you create an FX column? How do I adjust the formula in an FX column?

EvanShortreed

Good Afternoon,

This is set up as a column formula. To toggle back and forth and edit this formula, do the following:

1. Right click on the cell "declined by vendor"
2. At the bottom of the list convert to cell formula. This will remove the column formula and allow you to edit the formula.
3. To make a column formula, right click again and click "convert to column formula".

EvanShortreed

Good Afternoon,

This is set up as a column formula. To toggle back and forth and edit this formula, do the following:

1. Right click on the cell "declined by vendor"
2. At the bottom of the list convert to cell formula. This will remove the column formula and allow you to edit the formula.
3. To make a column formula, right click again and click "convert to column formula".

Stwillis

Thank you!