Referencing a date in another smartsheet

Options

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.

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    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


    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"