coldrainwater wrote:diaconia wrote:In terms of using the spreadsheet, I discovered that inputting everything correctly (so that it satisfies the IF-function) will be the biggest challenge for me!
In case it helps anyone, I am setting mine up for passive recall while letting my input column accept one of several correct answers taken from a list of words separated by commas (a comma plus a space to be exact). A screenshot of what I mean is probably the easiest way to show it. This would also work to allow multiple correct spellings if that was desired. I pasted the Google Sheet formula below so it can simply be copied and pasted as needed.Code: Select all
=IF(ISERROR(MATCH(D2,SPLIT(C2, ", " , 1,1),0)),0,1)
I updated the download with your formula! Thanks!