I use EXTRACTNUMBERS() to get numbers from a OCRTEXT() column.
This produces a list with numbers. The list may contain one, two, ore more values.
How to tell AppSheet to always select the last value?
I found a solution, but Iโm wondering if there is a simpler way?
INDEX(EXTRACTNUMBERS([OCRTEXT]),COUNT(EXTRACTNUMBERS([OCRTEXT])))
Solved! Go to Solution.
That syntax is fine
That syntax is fine
User | Count |
---|---|
43 | |
29 | |
24 | |
22 | |
13 |