Hi! I have a notion sheet with multiple numbers that are calculated together to get a profit. Currently, my formula says this:
if(prop("Uncompleted"), 0, prop("Profit outstanding") - prop("Quantity") * 2 * 0.65)
Basically, if the sale hasn't gone through, I don't want it to put anything in the profit column.
Now I want to add an additional property that says: if the sale has gone through AND if one box is checked, I want the formula to be the one above, but if the sale has gone through AND the box is unchecked, I want the formula to not include the "- prop("Quantity") 2 0.65" and I want it all to show up in the same column so the sum is correct. How do I do this?