Odd and pair words

AppSheet AppSheet Q&A
1

Hi there!
How can we count odd and pair words from several column in a row?

2

SABIO_Soporte:

odd and pair words

I’ve not heard this term before. Could you explain what this means?

1 Like
3

I need to count how many odd words are in a row.
And also need to count even words that are in a row.
odd word= two (3 letters)
even word= four (4 letters)

4

SABIO_Soporte:

I need to count how many odd words are in a row.> And also need to count even words that are in a row.

That’s not really possible.

Can you provide a better picture of what the larger goal is? Why do you want to know how many three (or four) letter words there are?

1 Like
5

This is not tested, but maybe you can try to use SPLIT(), with a space as the delimiter, then COUNT(SELECT()) with a condition of
MOD(LEN()) = 0
or
MOD(LEN()) = 1

2 Likes