I have a sheet on which 5 to 7 users are working concurrently to track their project time. We are trying to get current time when the user write Yes in the specified column or click the checkbox. However, Lots of the time, there is a difference between the time of updates of both the columns.
Col j - it is manual entry by the user
Planned and Actual are based on formula
Actual value - =if(H748,H748,if(J748<>"",$A$1,""))
In $A$1 = now()
Below is the snapshot for the reference