Help

How do you know when a cell changes

Topic Labels: Formulas
Solved
Jump to Solution
927 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Vijay_chen
6 - Interface Innovator
6 - Interface Innovator

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?
2

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

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

Thank you :slightly_smiling_face: :thumbs_up:

quyenvuong
4 - Data Explorer
4 - Data Explorer

How can i count how many time the cell had changed?