How do you know when a cell changes

[Vijay_chen]

I try the formula that IF({Date due}!=0,CREATED_TIME({Date due}),BLANK()), but the result is the created time of the row, not the date the {Date due} cell changes. What should I do?

[ScottWorld · Accepted solution]

Create a field that is a “last modified time” field type, and choose to update it only when the Date Due field updates.

[Vijay_chen]

Thank you :slightly_smiling_face: :thumbs_up: