I want the cells of two columns in my Spreadsheet to auto-update with the date (m/d/y) and name of user when cells in a certain range are edited. For instance, Catherine goes to sheet on 3/6/2017 (today) and edits information in either column A or B. Ideally, the current date would update in column C and the user's name in column D of the same row as the edits. I have included an image below detailing this example and highlighted the cells in yellow that should auto-update:
Cell last modified date & user stamp Google Sheets?
google spreadsheets;google apps script