Find Entry

PYI

I have different entries for same id . How to check what is the latest entry for that id

For exampe:

Bassam Khalil

Hi @PYI

Please check it now

Bassam Khalil

Hi @PYI

Hope you are fine, please add a helper column (checkbox type) call it latest and use the following formula in that column and convert it to column format formula:

=IF(MAX(COLLECT([submitted on]:[submitted on], id:id, id@row)) > [submitted on]@row, 0, 1)

it will check the latest entry, the following screenshot shows the result:

PYI

Perfect Mr.Bassam,,, Thank you so much,, works fine,,, one more question if id starts with 0 ,,,,should i have to change the formula?

Bassam Khalil

@PYI 

Please help the Community by marking it as an ( Accepted Answer)

PYI

I have tried out the formula , it works cool for all numbers,,,, but if its starts from 0,, results shows invalid operation.

Can anyone Please help me to find out

Bassam Khalil

Ok I will check it for you

Bassam Khalil

@PYI 

Please try the following formula:

=IFERROR(IF(MAX(COLLECT([submitted on]:[submitted on], id:id, id@row))
> [submitted on]@row, 0, 1), "")

PYI

thank you for your time,, i tried out but now its not checking the latest date for id which starts 0(0987)...

need your help... can you please have a look,,, thank you for your support ,,,,

Bassam Khalil

@PYI 

if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

PYI

I shared the sheet,, Can you please have a look.. Thank you very much.

Bassam Khalil

Hi @PYI

Please check it now

PYI

Great !! Perfect ....

Thank you so much Mr.Baasam,,, I really appreciate your kind help.....

Bassam Khalil

@PYI

You are welcome and i will be happy to help you any time.