Let’s say I have two fields sitting next to each other in a table. One is called Calculated and one is called Static. The Calculated field is, of course, a formula type field and the Static field is a currency type field.

I want to automatically save the result of the Calculated field as a static number in the Static field.

For example; if the Calculated field is a formula consisting of =10+5, then I want the static number 15 to appear in the Static field. I don’t want to formula itself in the Static field…just the result (15) of the formula from the Calculated field.

Does anyone know how I can accomplish this in Airtable?

Much appreciated.