I am trying to run a script that if a comment is made in column K, it then would timestamp the creation of that comment in column L.
"ExcelScript.Comment" interface makes it look like this is possible with "getCreationDate()" and "getLocation()". but with the initial function "main(workbook: ExcelScript.Workbook)" it doesn't want to work and for the life of me I cannot figure this out. Ultimately I am trying to get a timestamp in the L cell next to/whenever a comment is made in a K cell.
once the script works once it runs I was going to have it run in Power automate cause it doesnt matter instantly when the comment is made as long as when the script runs it kicks back "getCreationDate().