Initial Value + Reset on edit depending on a signature field

I have 3 columns:
[Name]
[Signature]
[Date]

My goal is: Set TODAY() as the initial value of [Date], after the [Signature] field is signed.
This is working, when I add a new row. But it is not working, when i edit an existing row.

So my workaround for column [Date] is:

Show if: ISNOTBLANK([Signature])
Initial Value: IFS(ISNOTBLANK([Signature]) , TODAY())
Reset on edit if: ISBLANK([Signature])

But this is also not working.
When I change it to:

Show if: ISNOTBLANK([Signature])
Initial Value: IFS(ISNOTBLANK([Name]) , TODAY())
Reset on edit if: ISBLANK([Signature])

It is working. But only if I 1. enter a Name and 2. sign in the signature field.
If I first sign in the signature field and then enter a name, there will be no initial value in [Date].

As far as I understand, we cannot refer to the same column in the Initial Value AND in die Reset on edit. Am I right?

0 3 772
3 REPLIES 3

How about a ChangeTimestamp field?

Thank you @Aleksi. In my case this is exactly what I need. Because I donโ€™t need to change the [Date] column manually. So I hide it and make it a ChangeTimestamp.

Youโ€™re welcome

Top Labels in this Space