I am doing right now the Daily activity report of our team and I need to consolidate and track the time stamp of each activity. My problem right now is once they filled up the activity with timestamp and after entering to a new activity, I would like to protect or not able to edit the previous step and time. I am using an Excel 2016
This is the sample table and the formula I used for the timestamp. Now I would like to seek your help, can I add another if command on the date, time started and time completed, let say there is already a data on that column it should not be editable. they can just add another main activity on the next blank row(below).
Thanks in advance.
Main Activity (E) Sub Activity (F) Date (J) Time Started (K) Time Completed (L)
Drawing Routeline Drawing =IF([@[Sub Activity]]<>"",IF(J1="",NOW(),J1),"") =[@Date] =IF(F5<>"",IF(L1="",NOW(),L1),"")
This is the sample table and the formula I used for the timestamp. Now I would like to seek your help, can I add another if command on the date, time started and time completed, let say there is already a data on that column it should not be editable. they can just add another main activity on the next blank row(below).
Thanks in advance.
Main Activity (E) Sub Activity (F) Date (J) Time Started (K) Time Completed (L)
Drawing Routeline Drawing =IF([@[Sub Activity]]<>"",IF(J1="",NOW(),J1),"") =[@Date] =IF(F5<>"",IF(L1="",NOW(),L1),"")
