Question about Lists

1

Hello!

I’m a bit confused about how lists work. I was building a Wordle type game and I have two tables. Word list & Guessing Table.

image
image1017×563 23.1 KB

So I have the Word from List column on the Guessing Table set to be this formula:
image

The First - Fifth Letter columns are select lists. I’ve got the conditional formatting set up correctly (green if it’s the right letter in the right column, blue if the letter is in the Word From list column but not in the right spot).

The Letter list column on the Guessing Table is this:
image

In the Solved Column on the Guessing Table, I want it set to true if the lists are the same. But I’ve tried a bunch of different combinations of formula comparing and just can’t get it to work. I checked the .Count() of each column and the .Count() for Word from List is 5 (as expected)
image
but the .Count() for Letter list is 1.
image

Could someone help explain what I’m doing wrong & why the Letter list column isn’t making them into a list? Thanks!

2

Hi Samuel,

That’s because lower() turned the list into a single string.
If you do this instead, you will iterate through the list and apply lower() to each element → [Whatever List].forEach(CurrentValue.lower())

Hope this helps,

Pablo

1 Like