Relative Content

Tag Archive for google-sheetstimestampgoogle-sheets-apisourceforge-appscriptrb-appscript

Is there a way to create a time stamp that records time a value in a drop down is selected?

I want a code in app script for google sheets, that records a (start time) time stamp when a value named ” بإنتظار وصول وثائق الزبون” is selected in the dropdown menu and then when it is no longer the selected value, to record the (end time) time stamp. But get this, the drop down is in a sheet called “Work Sheet” in column K3 and the time stamps have to be recorded on a sheet called “Data” in Column P3 (start time) and the (end time) in Q3.