Link to last added row in column A

A Rose

Hi,

Is there any formula to link to a cell in “[Column A]” for any new added row,

If any row added, it should link to the last added cell in Column A, is it possible?

Thank you!

Bassam Khalil

Hi @A Rose

Hope you are fine, you can add system column ( Modified Date ) to show the latest added row then use the following formula to collect the latest value added in column A.

=JOIN(COLLECT(A:A, Modified:Modified, MAX(Modified:Modified)))

the following screenshot shows the result.

A Rose

Hi @Bassam.M Khalil ,

The below worked!

=JOIN(COLLECT(A:A, Created:Created, MAX(Created:Created)))

Thank you for you help! 😀

James Keuning

Can you explain what you mean by "link to"? Do you mean - contain a hyperlink to? If so, which column in the new row should link to column A?

A Rose

@James Keuning ,

Hi, that’s correct link to Column A

any ideas?

Thank you!😉

ilyas star

Just = then select the refrence

A Rose

@ilyas star ,

the issue is that i want to refrence the latest row,

so if when someone submits a form it’ll refrence the latest cell in Column A, how would i do that?

Thank you!

Bassam Khalil

Hi @A Rose

Hope you are fine, you can add system column ( Modified Date ) to show the latest added row then use the following formula to collect the latest value added in column A.

=JOIN(COLLECT(A:A, Modified:Modified, MAX(Modified:Modified)))

the following screenshot shows the result.

A Rose

@ Bassam.M Khalil,

That worked, however if there was 2 form submissions in the same time, then it'll say duplicate..

any fix?

Thank you!😀

Bassam Khalil

Hi @A Rose

Please try the following to avoid duplicated

=JOIN(DISTINCT(COLLECT(A:A, Modified:Modified, MAX(Modified:Modified))))

A Rose

Hi @Bassam.M Khalil ,

I tested and tried adding 2 rows add a time and it's still duplicating.

Got any fix? pls let me know.

Thank you!

A Rose

Hi @Bassam.M Khalil ,

The below worked!

=JOIN(COLLECT(A:A, Created:Created, MAX(Created:Created)))

Thank you for you help! 😀

A Rose

Actually it's just the craeted date, but doesn't change if 2 were created at once.. Distinct also didn't work..