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

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.