Referencing a date in another smartsheet

Ileana Stover

Hello everyone,

I am trying to create a master smartsheet to give me the first date in a column in another sheet. I have tried cell linking but if a new row comes in it does not update. I don't know if this is possible but would appreciate any help.

Bassam Khalil

Hi @Ileana Stover

Hope you are fine, please add a new system column on your "created date" in your intake sheet to define the latest added column then you can get the information from this row by using the following formula:

=JOIN(COLLECT({Task}, {Created}, MAX({Created})))

{Task} reference the task column in the intake sheet

{Created} reference the created date column in the intake sheet

the following is screenshots shows the intake and master sheet