How to automatically change a value based on another value?
I do have a column where I insert a price, the value of an invoice.
That invoice however may be nullified later. It’s an YES/NO question.
If YES, invoice value should turn zero… or a “-” (not sure I can have a price as “-”)
However, using a VALID_IF doesn´t change the value. It just makes previously inserted values into illegal (a red underline).
Using an APP formula grays out the field so I can´t even insert a value in the first place (I used a IF… if([nullified]=“Y”, 0, [invoicevalue]+0)
I guess a Show_If would hide the value, but not delete it.
In fact, when nullifying the invoice by selecting YES, it would be best to just delete the Value field, as well as a few other value columns (Liquid Value, Receiving Date, Received Value, Tax Returns)