How do I add one cell of data once created into another sheet?

Hi

When a new row is created in Sheet A it is given an auto number. I then want to tell Sheet B that a new row has been added, or rather I want to show the new auto number in Sheet B. But only for rows where another column meets a criteria i.e. we log a certain name and so only want to send the auto number where the column has text "xx" in it.

In Sheet B the auto number will then be used in a data mesh between the 2 sheets....I just needed to get the unique identifier in each sheet.

Any ideas??

Thanks

Answers

  • Monique_Odom_Comcast
    Monique_Odom_Comcast ✭✭✭✭✭✭

    Hello @David_Workman1!

    Since you're already using Datamesh between the two sheets, would using the "Copy and Add New" function work for you? This would allow the Datamesh to recognize when a new unique identifier has been added and automatically add it to Sheet B.

    If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!

    Monique Odom

    Business Process Excellence Manager

    Smartsheet Leader & Community Champion

    Pronouns: She/Her (What’s this?)

    “Take chances, make mistakes, get messy!” – Ms. Frizzle

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!