'Timestamp, Date issue in Google Sheets

I am trying to get a timestamp to show in Col K5:K50 (TimeSubmitted) when col E5:E50 (Total Topics) is edited by a student from a tab each student was assigned with an =IMPORTRANGE command I made for them. I can get the timestamp to work but when I open the sheet each morning it automatically updates everyones time/date in the Time Submitted ColK

I only want this to work in the "tab/sheet" that is named "Quarter4 Daily Report2" at the end

https://docs.google.com/spreadsheets/d/1Lswf1O2orQN2IdGYd7gGIeqQibgVvYxcHOrMPHfUEJ8/edit?usp=sharing

I have tried other scripts than the one that's loaded but I don't always know how to edit the script to work with my google sheet. Stephanie

I tried several scripts but couldn't get the correct Row and Columns to match and work in my google sheets

timestamp getdate

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Timestamp, Date issue in Google Sheets

Sources

Related Questions