Hii in google sheet i have some columns you can see in screeshort image what i want if i selected status 1 as Start then Timestamp will come in Actual Timestamp 1 columns and if Status 2 is selected as End then Actual Timestamp 2 get Timestamp.
Hi @Vishal101
To achieve your goal, in the Type Details, Select your Column Status 1, this is to trigger that if you click a button Start in the Column [Status 1], then it will automatically change the Actual Timestamp 1.
For Reference:
Actual Timestamp 1
Actual Timestamp 2
Note: You don’t need to put initial value in the both Actual Timestamp because you set a Columns to watch for changes.
As results, please see the attached picture.
1 Like