Currency Format not working in smartsheet column formula

ygoldgrab ✭✭✭✭✭


I have 2 columns. Check Amount and Amount Paid. The Check Amount column has a column formula that copies data from the Amount Paid column -- This is the formula=[Amount Paid]@row.

I clicked the currency icon on to format my Check Amount and Amount Paid with the dollar sign. This worked.

The problem is that going forward, any data that gets copied from the Amount paid column to the Check Amount column is not formatted with the dollar sign.

Any ideas?