If and Checkbox


How do I create a formula for the following?

If the checkbox is check and the other checkbox is check [Total Sales]@row * [Payout Rate]@Rowena Cabiles

=IF([Billable Hrs Qualify]@row,1,AND([Total Sales Qualify]@row,1,[Total Sales]@row * [Payout Rate]@row

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!