I realise this is a very basic question but I am at a loss to work out the undoubtedly simple solution.
I have a table with two columns. 1 with prices in Pounds 1 with prices in Euros. Not all the cells in each column are filled in depending on whether I paid in pounds or euros. I want a way to fill in the blank cells with either the equivalent amount in euros or pounds.
What I have tried so far will change the entire column to euros or the entire column to sterling but not the individual cells if you see what I mean, here is a link to a test document to see if some kind soul can put me out of my misery. https://coda.io/d/Test_dgW3pynpvJD
1 Like
Hi Charlotte,
Welcome to Coda, and the community! And since you were clever enough to find the community AND provide an example doc, you are no longer dumb, nor is this a dumb question.
Some questions to clarify the requirement first:
Do I understand the doc correctly, in that you want to regularly revalue to the latest rates, and keep a track of past revaluations?
Or do you simply want to revalue to the latest exchange rate? If so, do you want to keep the old rates, or are you satisfied with just capturing the latest exchange rate?
Depending on the answers to the above, your doc will look very, very different.
Regards
Rambling Pete
hi @Charlotte_Fisher ,
I assumed you may want to have a date specific exchange rate, so i added a table with dates and conversion dates to that table
based on that I created a button that contains the following:
buttons work wonders in these scenarios
the filter formula may look impressive, but is maybe less so if you look at some hidden columns I added with a few steps showing you how I got here.
Enjoy your weekend, Cheers, Christiaan
So I thought I could just have a fixed figure that I input somewhere eg 0.83 for euro and 1.20 for GBP
Then each cell could use those figures to calculate the amounts.
So in answer to your question just revalue to the latest exchange rate and I don’t need to keep track of historical changes. The simplest of simple things… thanks for being kind.
1 Like
Hi Charlotte,
This is as simple as I can get it.
I have an entry column, and then a converted column for each currency.
The value to convert with is captured in this select control:
And then the formula like this in the converted GBP column
And an inverted one to do the Euro Calculation.
Nothing wrong with the button approach - This is the beauty of Coda, many different ways to do things based on your style.
Regards
P
Great thanks so much both. Will have a play around with both approaches and see which one works for me! thanks again for taking the time.