I'm trying to modify my spreadsheet. Below is my original spreadsheet with the formula I used. Which works great for what I needed. But my boss is wanting time stamps for 3 different actions from column C. This time is frozen and doesn't change unless column C is put to blank then added a new word.
=IF(C3<>"",IF(B3="",NOW(),B3),"")
I have used the following formulas for the columns, but I have run into the time changing once column C is changed. Please Help I need these times to freeze.
Formulas used in each column:
=IF(C3="ASSIGNED",NOW(),I3),
=IF(C3="ON SITE",NOW(),J3),
=IF(C3="COMPLETED",NOW(),K3)