-1

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

-2

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.

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.