Link to last added row in column A


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!

Best Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    edited 04/14/21 Answer ✓

    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.

    PMP Certified

    [email protected]

    ☑️ 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"

  • A Rose
    A Rose ✭✭✭
    Answer ✓

    Hi @Bassam.M Khalil ,

    The below worked!

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

    Thank you for you help! 😀


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!