Hello, if I have a cell with a range of numbers in, as selected via a multi select, is there a formula that can add these numbers up and give me the total, for example i'd like a column that will show the total of the numbers in image of the cell att...
unfortunately, this isn’t an option. As the data is brought in automatically, it needs a single line text field for it to sync properly. What other solutions are there?
Thanks
It’s stored in another table as (for example) ‘6” - approximately 6-10 portions’
Unfortunately it’s not stored as just ‘6”’ tbh I don’t need the “ if it helps, just the number.
How would a regex function work?
