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?
Thanks!