About Stelio_Pappas

Stelio_Pappas · 06-28-2022

Hi allThis question follows on from a post I made yesterday@Steve helped me understand the single quote meaning which I can see below in another experiment:Using Steve's logic, the TestExpiryDate column (Q) above, is set to text (Format > Number > Pl...

Stelio_Pappas · 06-27-2022

Hi allI have an app that is reading a QR code that appears to be delimited by a newline "\n".A typical QR code (which I don't have control over) looks like this:AC123456\nJoe\nBloggs\n01 Jan 1970\nJane Bloggs\n0412 345 678\nMy Cycling Club\nRace - Al...

Stelio_Pappas · 07-27-2021

Hi all, Does anyone know a technique for extracting a range of values from a sorted list of variable length? I can already get the TOP() 10 values, but I need to get the next range. Eg I need to get values 11 to 20. My apologies for asking this twice...

Stelio_Pappas · 07-22-2021

Hi all My “little” appsheet project is starting to become bigger than Ben-Hur. I have an appsheet table with many rows, but only a few columns which I need to print. To avoid spanning too many pages, I was hoping to take advantage of the Column featu...

Stelio_Pappas · 07-15-2021

Hi all I’m hoping for some guidance on how to automate a bot to create a file with an empty table to a specific number of rows. BACKGROUND I need to produce a sign-on sheet with three tables on one PDF page. I have colour coded them for clarity. Red ...

Stelio_Pappas · 06-30-2022

Thanks @Steve -That did the trick. I was very careful to check MMDD Vs DDMM but didn't realise the Text to Date format limitation when being interpreted.@Aurelien it seems the other date appeared to be working simply because MM & DD were both less th...

Stelio_Pappas · 06-29-2022

Hi Aurelien, thanks for the tip. The locale is already set to Australia for both Sheets and the app.There are actually two date fields in each row. One is DoB and the other is Expiry Date. They are both in the same format and are handled in the same ...

Stelio_Pappas · 06-28-2022

Thanks Steve, that makes sense and explains why I didn't see it until I used the INDEX function.The weird thing is that both dates were working at one stage, but the app one day starting having issues with the second date so I started messing about t...

Stelio_Pappas · 07-28-2021

Hi all, I ended up with my home-brew 2 cell x 1 row table option. @Suvrutt_Gurjar, provided the (real) expression to replace my (fake) MIDDLE function here: Range of values from a list Questions Hi all, Does anyone know a technique for extracting a r...

Stelio_Pappas · 07-28-2021

That is excellent. I was very close. I remember thinking if only there was a way to chop off the first 10 values. -It never occurred to me to subtract one list from another. Thank you @Suvrutt_Gurjar!

My Stats

MiguelQ90's Bio

Badges Stelio_Pappas Earned

Recent Activity

Date Format

How To Clean Up Special Characters

Range of values from a list

Google Docs Column Feature

How to create an empty table

Re: Date Format

Re: Date Format

Re: How To Clean Up Special Characters

Re: Google Docs Column Feature

Re: Range of values from a list