I am trying to use to use the following formula in an excel document: =IF(C2="","",NOW()). I'm just trynig to capture the time that a cell is populated. The problem I am running into is that everytime one formula updates, they all update.

For example, if I have the two formuals:

=IF(C2="","",NOW())
=IF(C3="","",NOW())

If I update C3, the formula that relates to C2 also upates. So my times are always identical to the last updated cell. I can't get them to update when only there dependent cells update.

One other thing of note, this spreadsheet is being used in MS Teams, so macros are not an option.

Is there a setting I have incorrect potentially? Or a work around?

Thanks in advance!

CodePudding user response：

Have you looked into Office Scripts? They work a lot like macros in VBA, but they are for Excel Online.

The code above checks to see if a timestamp is already filled before setting it.