I’ve tried to work this both using just the formula and also a combination of the formula and conditional fields (which seems like how it was designed to be used).
I have an Inventory table that contains our inventory. I have an Orders table that con...