IF Yes, Add Columns | Airtable Community

Column #1

{Need Hotel?}

Yes or No

Column #2

{Hotel Cost (Estimate)}

{Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)}

What I need is to change the column in #2 so that If {Need Hotel?} = Yes, then Do {Estimated # Staff} * 250 * {Duration (Days) (Do Not Edit)}

Page 1 / 1

Make your second column a formula field with this formula:

IF({Need Hotel?}='Yes', {Estimated # Staff} * 250 * {Duration (Days)(Do Not Edit)}, 0)

Thank you. That worked perfectly.

Sign up