Reference a cell and make the value static?

Zach_

Hi there.

I'm in need of validating the status of a resource by comparing to dates: last modified and the date/time the item was moved to the sheet. I want to request an update if the two values are identical.

Here's what I have right now.

• The Last Modified column doesn't require any explaining.
• The "Last Modified" Converted to Text column is self-explanatory. (formula: =[Last Modified]@row + "")
• In the Entered Inventory Static Date field, I want to copy over the "Last Modified" Converted to Text value BUT prevent it from changing when the row is modified.

How can I do this?

Adam Murphy

Only way I can think of is to use a helper sheet and copy rows automation to copy that record to the helper sheet, then use an index/match formula in the Entered Inventory Static Date field to retrieve the value from the helper sheet. You'd probably want to include logic in the automation to only copy the row when Entered Inventory Static Date is blank to keep it from running all the time. Would that work?

Zach_

Thanks for the response, @Adam Murphy. I thought of that, too. It would solve the problem, but to me, that's more of a last resort.

Adam Murphy

Ok, only other option I know of is to use api and script it.