Write Function that has 2 check boxes in it?

edited 12/09/19 in Formulas and Functions

Hi everyone, I have had smartsheet for awhile and finally taking the time to learn/use it and am stuck. I have a custom apparel business and have made a sheet to keep track of all my orders and what the cost will be.

I have columns for Quantity, Balance, No Fulfillment (check box), and Paid (check box). I have a working function that fills my Balance by multiplying my cost (20) * Quantity and removes the balance when the check box under Paid is checked -

=IF(Paid1 = 0, Quantity1 * 20)

So, 20 is my cost with fulfillment, but I would like to be able to check No Fulfillment when needed and it changes my cost to 18, which changes my balance and still having it removed when clicking Paid.

=IF(Paid1 = 0, Quantity1 * 20), IF(No Fulfillment1 = 1, Quantity1 * 18)

Even I am confused by how I wrote this, but can anyone help?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!