Updating a date column only when a column has true mentioned in row

[Kaushal_Didwan1]

Hi,

I have a sale order form and I have 2 column, 1 column(yes/no) where a user inputs if the order has been dispatched . and another column mentioning the date of dispatch. the date should be automatically calculated when the user enters true. How can we achieve this?

[Aleksi]

You need to use ChangeTimestamp column type. Please check this article…

help.appsheet.com

Tracking Changes Using "Change" Column Types

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

[Mitchell_Cole1]

Set the value in the formula section of the column to If([column 1]= yes, TODAY(), " ")

[Aleksi]

@Mitchell_Cole That won’t work correctly. If the user opens the record after the column’s value is changed to “Yes”, it will update the date value. With the ChangeTimeStamp it will do it only when the value is changed.

[leahcarn]

This sounds very similar to what I’m trying to do. I’m wanting to have a “last active date” for a user, based on their activity in a different spreadsheet, but I can’t figure out how to make the ChangeTimestamp column dependent on a column in a different spreadsheet. Or is there a different format I should be using?

[Aleksi]

You can’t use ChangeTimestamp field for that purpose. You have few options how you could do that… with a virtual column in users table or actions when the child table’s value is changed.

[leahcarn]

Thanks Aleksi, that’s really helpful. How would I code that?
Something about “return the date column for the most recent mention of matching name in x sheet, column”? And put it all into the formula section of the “last active date” column in the users tab? I’m having real trouble figuring out what expressions to use to write it