Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
I Need the Logged User Name in Column C When he enter the cell from drop down list Selection in Column D In Google Sheet I have number of users to use one sheet they Have a list of drop down selection in Column D When they fill the column one by one I should get the logged user name in Column C one by one.
In Column D3 D4 and D5 ...... if he select the cell value I should get his name in Column C3 C4 and C5 ......
Hope some one will help me out
Its simple, no need to complicate things with codes & formulas just Create a Form & from the form settings set the form to Collect the Users email address everytime the form is submitted- you just need to collate the data of eeach user the first time to link each users name to their email addresses incase they using personal email addresses-put the drop down list on the form not on the sheet.
The Form Response sheet will have all the data you need once the users submits the form.
