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

AppSheet AppSheet Q&A
1

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

2

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”

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

4 Likes