How to create a FX Column
Options
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?
Best Answer

Good Afternoon,
This is set up as a column formula. To toggle back and forth and edit this formula, do the following:
 Right click on the cell "declined by vendor"
 At the bottom of the list convert to cell formula. This will remove the column formula and allow you to edit the formula.
 To make a column formula, right click again and click "convert to column formula".
Answers

Good Afternoon,
This is set up as a column formula. To toggle back and forth and edit this formula, do the following:
 Right click on the cell "declined by vendor"
 At the bottom of the list convert to cell formula. This will remove the column formula and allow you to edit the formula.
 To make a column formula, right click again and click "convert to column formula".

Thank you!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!