Right now, you can create a value for a row when it is created.
I often find that there are workflows my users have where they might need to input a custom value, or the value might be inferred from context after the row is created.
For example, if an electrician needs to service a home, the address of the location that they are servicing and the billing address of the customer are often the same. Sometimes, however, the billing address and the service address are different and it needs to be updated.
I’d like to have my column autofill with a formulaic value if the cell hasn’t been manually filled, but I’d still like the user to be able to override it.
The workaround at the moment is three different columns: Override Address, Inferred Address, and Final Address.
The formula that controls Final Address is:
Override Address.IfBlank(Inferred Address)
But this forces my users to know to use the Override Address column when they want to change a value, and often their first inclination is just to click on and change Final Address.