I am using excel to develop a stock management sheet. The worksheet (called Action Sheet) is laid out with code(A), name(B), date(C), action(D), user(E) and quantity(F & G).
The name column uses the cell formula [=LOOKUP(‘Action Sheet’!A:A,’Chemical Lookup’!A:B)] to update itself from another worksheet (Chemical Lookup) when an entry is made in the code column.
I want to a similar task in the date column [=IF(A2>1,$I$1,””)] (I1 is =TODAY()) when an entry is made but want the date to remain static for the entry i.e. I do not want the date to change when I am making further entries on a different date.
Please help as this is beginning to drive me nuts!
my requirment is that when i change the status to “Closed” then automatically the date should appear in the next column.
i tried using today and now function but issue with this is that if one record is changed all dates get reflected by same date
I tried the following but it is not helping
=IF(H3=”Resolved”,+NOW(),O3)