Merge Airtable columns conditionally

How can I achieve conditional multiplication between columns in Airtable?

I need to set up a column that multiplies a value from one record by a value from another record located in a different column, but this should only occur when a specific checkbox in another column is marked as checked. I appreciate any guidance on this topic.

Hey, I’ve done something similar before! You can try using formula fields, and even combine it with “IF” conditions. Take a look at how IFTTT works with records. Toggle the checkbox first, then let your formula trigger. Airtable can be tricky but it’s pretty powerful! good luck :slight_smile:

Yea, Claire’s right. You can setup a formula with IF statements. Make sure to use IF(CheckboxField, ColumnA * ColumnB, 0). Just replace ColumnA and ColumnB with your actual column names. And pay attention to the field types, that can cause issues!