Need script for Google Sheets to add a namestamp

[Kanger14]

Hello,

I am looking for a basic script that would paste a users name in a cell to the right when a condition is met (for example when column Q value is TRUE).

I would even settle for having the editors email address paste into the cell.


Thank you!

 

[VBE313]

Google Sheets is very strict when trying to get the active users's name. You need to to authorize script projects that access your data or act on your behalf. However, even with user authorization, you still cannot use Session.getActiveUser() in custom functions (directly in cells). You need to create a custom menu instead. If you have any other Google Sheet questions, I would advise you to ask it on stackoverflow.com.