Hi everyone,
I have a single table/view containing a 'Planned Quantity' column. The concept is that when a user edits a row, the 'Real Quantity' column, initially set to 0 or null, should be updated with the 'Planned Quantity' value only if it is 0 or null. In this scenario, I can't utilize an initial value because I'm not adding a new record.
Use:
OR(ISBLANK([column]), 0 = [column])
Here:
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |