Date Auto update issue

[Sirfyaad]

I want that when I enter any data in the [table Person name], the [sticker complete date] should be auto filled.

 

[dbaum]

In the [sticker complete date] column, enter an initial value expression like the following:

IFS(ISNOTBLANK([table Person name]), "Sticker Complete")

Enter a reset on edit expression like the following:

AND(ISBLANK([_THISROW_BEFORE].[table Person name]), ISNOTBLANK([_THISROW_AFTER].[table Person name]))

[Sirfyaad]

@dbaum  Thank you for your reply. I have two date columns in my sheet. But when my user enters the data in the form, the date automatically appears in both date columns.

I want that on whatever day I edit the [sticker person], the date of the same bin should be entered in the [sticker complete date] column. 

[dbaum · Accepted solution]

---

@Sirfyaad wrote:

But when my user enters the data in the form, the date automatically appears in both date columns.

---

If you don't want the date to be the column's initial value, then clear the column's initial value property.

---

@Sirfyaad wrote:

I want that on whatever day I edit the [sticker person], the date of the same bin should be entered in the [sticker complete date] column.

---

I don't know what you mean by "bin". Nonetheless, it sounds like you may be able to accomplish what you want by applying the technique I described but correcting it for whatever mistakes it reflects in my misunderstanding of which columns you're referencing and what data you want. Perhaps you're looking for the following:

In the [sticker complete date] column, enter an initial value expression like the following:

IFS(ISNOTBLANK([Sticker Person]), TODAY())

Enter a reset on edit expression like the following:

AND(ISBLANK([_THISROW_BEFORE].[Sticker Person]), ISNOTBLANK([_THISROW_AFTER].[Sticker Person]))

[dbaum · Accepted solution]

Enter a reset on edit expression like the following:

AND(ISBLANK([_THISROW_BEFORE].[Sticker Person]), ISNOTBLANK([_THISROW_AFTER].[Sticker Person]))