Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
May 26, 2021 02:43 PM
Hey guys, so im working on an invoicing system.
I have three columns: Item Price, custom price, and applied price.
I’m in need of a formula for the applied price column that says "default to item price, but if custom price is > 0 use that custom instead.
any takers??
May 26, 2021 05:45 PM
IF(
{Custom price} > 0,
{Custom price},
{Item Price}
)