Skip to main content
Solved

How do you know when a cell changes

  • July 23, 2020
  • 3 replies
  • 31 views

Forum|alt.badge.img+9

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?

Best answer by ScottWorld

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

3 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9773 replies
  • Answer
  • July 23, 2020

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


Forum|alt.badge.img+9
  • Author
  • Known Participant
  • 19 replies
  • July 23, 2020

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:


Forum|alt.badge.img
  • New Participant
  • 1 reply
  • March 23, 2023

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