"oracle" or "oracle_text" value only fills cell with the first line of text

scryfall / google-sheets

Custom =SCRYFALL() function for Google Sheets

69 stars 12 forks source link

"oracle" or "oracle_text" value only fills cell with the first line of text #23

Open thelamesaucegit opened 3 months ago

thelamesaucegit commented 3 months ago

Using the formula to fill a column with oracle text for card names found in adjacent cells in the next column over only fills that cell with the first line of text from the oracle value. Example formula:

=IF(B370 = "", "", SCRYFALL(CONCATENATE("!",char(34),B370,CHAR(34)),"oracle"))

Where "B370" = Kudzu results in the cell only containing "Enchant land"