I have a text-type virtual column with the app formula [word list]-[words I know] resulting in only showing the words missing from the word list.
[Words I Know] is an enumlist, [Word List] is a list-type virtual column with the app formula LIST(word1, word2, etc).
Everything functions as it should however and words that have 1, 2 or 3 letters from the resulting list are capitalised. How do I stop this?
Solved! Go to Solution.
Please try for the resulting list
LOWER([word list]-[words I know])
If you need the resulting column strictly to be list, you may need to use SPLI() to create a list again.
Please try for the resulting list
LOWER([word list]-[words I know])
If you need the resulting column strictly to be list, you may need to use SPLI() to create a list again.
Thanks - this worked. Any insight as to why these words were being capitalised?
User | Count |
---|---|
44 | |
31 | |
29 | |
14 | |
14 |