Update date based on change in a specific column

[gasmech]

I'm new to AppSheet and working on my fist app. I have a maintenance tracker app that contains only one sheet. I need to update the column "Total Hours Updated" to todays date each time the "Total Hours" column is updated. I set up an action to set the value of "Total Hours Updated" to = TODAY(). The action is triggered by an automation with Data Change Type set to Updates. How do I restrict the automation to trigger only when the specific column "Total Hours" is updated. Right now it will run when any column in that row is updated. If I update "Last Service Hours", it will change "Total Hours Updated" to todays date, even though there was no change to "Total Hours"

[WillowMobileSys]

There is a column type of ChangeTimestamp.  You can configure it to only update when certain columns change - in your case only when the Total Hours changes.   This will record the value in "timestamp" form but then you can use date and time functions to get the date and/or time in a more human readable format if you need to display it.

I hope this helps!