Coming soon - Get a detailed view of why an account is flagged as spam!
view details

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.

1
Is there a way to exclude a range from an onEdit trigger? Or an alternate way to solve my problem? Noob in distress!
Post Flair (click to view more posts with a particular flair)
Post Body

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!

Author
Account Strength
100%
Account Age
5 years
Verified Email
Yes
Verified Flair
No
Total Karma
4,776
Link Karma
576
Comment Karma
4,192
Profile updated: 3 days ago
Posts updated: 3 weeks ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
2 years ago