All cells updating as a group instead of individually

[Irishtone]

Hi all,

I have created a workaround for a problem where I wind up with the following :

Column AM contains the following formula:

=IF(ISERROR(AN5),"No Update",NOW())

Coumn AN is looking into another sheet and telling me if there is info in a range of cells or not.

What I want from Column AM is the date and time that the last update took place in the referenced file (AN is looking into)

It appeared to be working, but when I update any cell in the selected range in the reference file. ALL of my "Update" dates recalculate.

For example , If I make it so that the value in AN4 updates. Then the update time for any AM cell where the above IF function is false recalculates.
This makes no sense to me.....

 

[Oaktree]

NOW() is a volatile function. It recalculates whenever a calculation is triggered.

If you want to conditionally apply the current timestamp only one time (i.e. *not* have it recalculate), you'll need to use macros.

 

[Irishtone]

Sheeeeeeee-id,
I thought as much.
OK, thanks for the clarification Oaktree.

T