Skip to main content

Hello Everyone,

I am a gallery assistant and trying to convince my director to move to Airtable!
However, I meet some issues, hope anyone can kindly help me.

So there will be two groups of product prices, one is (A+B), and the other one will be the amount we type in.

Can the formula do something like If(Checkbox=1, “{A+B}”, “manual enter”) or something like this?
Sorry really bad at this.

Hope anyone can give me some ideas about this

Hi @Kc_chen,

Yes, you have a few options. I would suggest creating a field/column named ‘Manual Price’ and create your Formula field.

In the formula field use IF({Manual Price}, A+B, {Manual Price})

You can then format the formula field to display in a currency format.

Hi @Kc_chen,

Yes, you have a few options. I would suggest creating a field/column named ‘Manual Price’ and create your Formula field.

In the formula field use IF({Manual Price}, A+B, {Manual Price})

You can then format the formula field to display in a currency format.


Thank you so much that does help!!

Terms & ConditionsAccessibility statement