Log In
Register
Home
January 30, 2020
Offline
Hi There,
I have a workbook for my warehouse where orders are either in print short , In Process or Completed.
In Column C where a person selects data validation IF in C is "In Process" or "Completed" a time stamp entered if column H. The formula below as follows:
=IF(C3 = "Completed", NOW(),"")
However, ever time I select another cell the timestamp follows through on all cells. I would like just the one cell with different timestamps entered.
I am aslo interested if you can include "Completed" &/or "In Process" Formula I tried.
=IF(C5="Completed",IF(C5="In Process",TODAY(),D5),"") and still doesnt work
Thanks
Moderators
January 31, 2022
Online
Such a time stamp would require a change event in VBA or a formula that requires iterative calculations (File, Options, Formulas, ....)
VBA is not my thing, so I can't help you with that but the attached file has the formula option that could work for you.
The formula in H2 is as follows:
=IF(OR(C3="Completed", C3="In Process"), IF(H3="",NOW(),H3), "")
1 Guest(s)
