I have 3 fields: Qty, PriceEa and Total.
Pretty simple Qty * PriceEa = Total setup.
I want the users to be able to enter a number into either the PriceEa or the Total fields, and have it calculate the other.
So, if the Qty is 10 and the user enters 2 into PriceEa, the Total field updates to 20.
But, then if the user changes the Total to 25, I want the PriceEa field to update to 2.5.
I thought I could do it with auto-enter calcs, but that doesn't appear to be working.
Do I need to set it up using ScriptTriggers? Not a big deal, I was just hoping to have something that worked at the field level, rather than requiring that trigger setup on every layout.
Or if you have a better way, I'm all ears!