Welcome!

TODAY Formula Constantly Changing Date to Current Date

Hi - We have a formula in a sheet

=IF(Status@row = "Closed", TODAY(), "")

That when the status at the row changes to closed, it was to add todays date in the Date Closed Column. However, it seems that it is now changing the date for anything previously closed to the current date. We need it to change it to the date when the status changes to closed, and not change it again. Can anyone tell me how to fix this?

Find more posts tagged with

Sheets

Formulas

functionality

Comments

DKazatsky2

Hi @AmyBurns_BCD,

Instead of using a formula here, you should setup an automation to record the date when the value changes to "Closed".

The automation should look something like this.

Hope this helps,

Dave

Sign in to join the conversation!

Quick Links

Trending discussions

Formula with date column weirdness
Hi all! Happy Thursday. I have a formula that I created that is looking to calculate a number of cells that meet the specified criteria on a particular cell that inputs a date when a box is checked through an automation. What I am noticing however is that the formula is calculating items that are earlier than the specified…
TODAY Formula Constantly Changing Date to Current Date
Hi - We have a formula in a sheet =IF(Status@row = "Closed", TODAY(), "") That when the status at the row changes to closed, it was to add todays date in the Date Closed Column. However, it seems that it is now changing the date for anything previously closed to the current date. We need it to change it to the date when…
Can I Reference Another Sheet in Table View?
I am trying to move more of my Grids over to Table View, but am not able to find a way to reference another sheet in Table View, aside from using the Dynamic Dropdown option, which is not what I need, since I'm working with formulas. Is this available in Table View? I haven't been able to find anything on it.