Help

Record Updating with Multiple Dates

Topic Labels: Dates & Timezones
591 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Office_Manager
6 - Interface Innovator
6 - Interface Innovator

Hello,
I have a table that I would like to show when certain things were done in each Apartment. For example, when we painted it or replaced the fridge etc.

I have the formulas to insert the date these things occurred. At first, I used IF(Paint=BLANK(), BLANK(), TODAY()) but that would update the records every day. I then thought IF(Paint=BLANK(), BLANK(), LAST_MODIFIED_TIME()); however, I just went to one suite to say we just painted (we finished today) but the fridge date also updated to the last modified time.

Let’s use 701 as an example. Below shows the fridge was replaced 4/6/2021 but as soon as I say we painted all dates will update

image

image

Is there a way to keep the dates as is and up date only when the column in the formula is updated and not the entire record?

0 Replies 0