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])))