Fill a column with TODAY() when a user selects an option from a separate enum column

[Josh_Klassen]

Hi,

I would like a column [Invoice Date] I have to be filled with TODAY() when a user selects “Invoiced” from a enum column [Status]

Thanks,

Josh

[Suvrutt_Gurjar · Accepted solution]

Presume that the [Invoice Date] column needs to be filled in with TODAY() only by the status of the [Status] enum column being “Invoiced”

if so , I believe you could use ChanbeTimeStamp time column to change based on [Status] column and Change Value being “Invoiced”

help.appsheet.com

Tracking Changes Using "Change" Column Types

How to keep track of when and where data is changed in your app.

https://www.appsheet.com/samples/Keep-track-of-when-columns-change?appGuidString=8a1572da-c548-418c-...