Printing cell history value

I have A1 and B1 which are two different dates (for illustration: A1 is today's date, and the other in the following day). I have data value in Cell C that is changed daily by another cell linking formula from other sheet.

Then I have cell A2 and B2 -- the formula in these cells is: =IF(today()=ColumnA1,CellC) and =IF(today()=ColumnB1,CellC) respectively i.e. the formula looks at the date in the A1, for cell A2 and date in B1 for cell B2; and takes the value from CellC if it matches todays date. In cell B2, it will look at the value in CellC for the following day. The formula works ok, except the data in A2 becomes empty the following day (Value in B2 works as intended).

How do I retain the value in cell A2 from being changed/emptied after the date is no longer today i.e. the following days? I can see that the cell history has the previous day's data.

Is there a formula like this:

=IF(today()=ColumnA1,CellC,Use_Cell_History_Last_Value) ?

Find more posts tagged with

Sheets

Calendar View

Formulas

Reports

Solution Center

Community Platform

Conditional Formatting

Update Requests

Cell linking

Enhancement Request

Email Notifications

Comments

Shaine Greenwood

Hello,

Due to the way that the TODAY() function works, you'd need to manually copy the data from A2 into another cell (that doesn't use a formula) in order to retain it. This is due to the way that the TODAY() function and IF() function works, TODAY() always calculates the current date. If this causes the IF statement to no longer be true, it won't return a value—leaving the cell blank.

GG_User

Thanks for the feedback.

I wanted to avoid the manual copying of data as the today() function wont retain the existing value. But the cell retains the history value. I would like to access this history value and print out in the cell if TODAY() doesnt equal to the current date. I guess this function (to recall history vaue) is not available yet?

GG_User

Hi all, sent this to FEATURE REQUEST. Please share the love

Sign in to join the conversation!

Quick Links

Trending discussions

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…