This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
Edit: Problem solved, and WAY simpler than I was trying!
I feel like I'm close to finding the answer, but am struggling to figure it out. I have a chunk of code that uses appendRow to create a log/history of changes to a specified cell, which outputs a date and the total of that cell before it changed. I'm TRYING to have the date column be formatted a specific way, as I need to then have yet another cell reference those dates and totals- the only way I've figured this out is to set a macro that changes the date format when a new entry is made by the appendRow function. The issue here is that when the macro runs, the sheet recognizes it as an edit... and inputs another row, which won't work for the second cell reference. So, I'd like to exclude column A from that onEdit function. Is there a way to do this???
If need be I can link to a copy of the sheet with sensitive info removed, but any help would be appreciated by this noob! Ty in advance!
Subreddit
Post Details
- Posted
- 2 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/GoogleAppsS...