copy same value to another column

AppSheet AppSheet Q&A
, , , ,
1

Hi there,

I have a table called orders. Inside it there are two columns of type date.

Fulfillment date

Task date

I want the initial value for the task date to copy the same date of the fulfillment date. I have tried this but has not made any change. [Fulfilment Date].

also note I should be also able to modify the task date manually if I need to.

Thanks indeed

Untitled.jpg
Untitled.jpg1366Ă—597 88.4 KB

2

Your formula is correct with the initial value, but it only affects when you add a new record and you don’t touch that field before the original date column is filled.

3

@AleksiAlkio Oh yes that is true. Is there a way to update it even if it’s updated again later

4

You could use the option “Reset on edit”, but you need to think how to control it.