Having trouble getting my function/script to run on Sheets

[Kenny Dean]

Hi there, first, thanks for helping!

I'm a complete noob at this. I'm just trying to do some fun things in my free time. I'm an advanced Sheets user, but I want to gather data from an API for a game I play so I can do my Sheets magic. 

I'm kind of going off what someone else has done, so forgive me if it's not the most elegant.

I've got a Drawing in sheets with the assigned script "getDrugData". I have an Apps Script with a function of getDrugData(). I've confirmed that the Apps Script is deployed as a test on my sheet. (I do notice it says "Disabled" but I'm not sure how to fix that, or if that might be related to the issue).

When I try to click the drawing to run the script, it says "Script function getDrugData could not be found"

Any advice would be appreciated! Thank you!

[Brett Grear]

Have you ran your function once from the Apps Script editor to give it the permissions it needs to access your account?

If so, I would need to see a copy or screenshot of your function to give me an idea what might be the cause.

Also a screenshot of the AssignScript popup associated with the Drawing might provide some insight as well.