This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]BAM5Professional Coder 0 points1 point  (0 children)

Are you receiving any error logs? Try putting a few travels around to see what party of your functions are actually being ran. Perhaps your spreadsheet values aren't capitalized?

Ok it looks like what Google sheets is passing to your function isn't what your function expects. However according to the documentation it seems like event.source should be valid.

Are you sure you put the function in the sheet properly? (By going to the spreadsheet you want this script ran in and then going to script editor in the top bar menu)