Harry_Batten - profile

Harry_Batten · Jun 11, 2023

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...

Harry_Batten · May 22, 2022

Hi, IS it possible to sort this list of times, earliest to latest? I can only sort A-Z and this is what it returns:

Harry_Batten · May 22, 2022

Hello, how can I extract the 6" and the 8" from these strings?

Harry_Batten · May 29, 2022

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

Harry_Batten · May 23, 2022

Amazing, that did it, many thanks!

Harry_Batten · May 23, 2022

Thanks, I think i’m doing something wrong with it though as its giving me an error message.

Harry_Batten · May 23, 2022

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?

Harry_Batten · May 23, 2022

Thanks for your reply, how would I use that formula in this instance?

User Statistics

User Activity

Summing Number in Multi Select

Sorting time earliest to latest

Extracting a number from a string

Re: Sorting time earliest to latest

Re: Extracting a number from a string

Re: Extracting a number from a string

Re: Extracting a number from a string

Re: Extracting a number from a string