Using Cell References - Githubissues

scryfall / google-sheets

Custom =SCRYFALL() function for Google Sheets

72 stars 12 forks source link

Using Cell References #14

Closed garrro01 closed 2 years ago

garrro01 commented 2 years ago

I am trying to use this to determine the current value of my collection. If I have a Set Abbreviations in A1 and a Card Name in B1 I want to show the current value in C1.

In C1 I have the following code: =SCRYFALL("set:"&A1&", card:"&B1&, "prices.usd")

However I get an error: Error Formula parse error.

Right now as an example A1 is MH2 and B1 is Dauthi Voidwalker which means C1 should show 7.86 at the time of me posting this

garrro01 commented 2 years ago

I have made a work around by using a formula to make a string of the search in a hidden cell and can then reference it with no issue.