Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Automatically import data from one sheet to another?

    ✭✭✭
    in Formulas and Functions

    I'm finding a few different answers but not sure which one pertains to my situation exactly. I have created a smartsheet with a form that is an application for students to apply to be a part of a team. I then have a second smartsheet where their applications will be scored. Is there a way to send certain data (not all) from the first sheet (application) automatically to the second sheet (scoring) as it comes in?

    I know I can link the cells, but to my knowledge, I would have to go in and link each individual column and it wouldn't be automatic. I'd have to update manually every so often. I've also read about formulas but none of them seem to apply to my exact situation.

    Is this possible or no? If so, how, please?

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • ✭✭✭✭✭
      Answer ✓

      You can make an automation to move rows from one sheet to another, Unfortunately it will copy over the other information but you can hide those columns on your second sheet.

      1) Automation is located in top left corner

      2) Create flow from template

      3) Choose " Move a row to another sheet when specified criteria are met" template.

      4) Follow steps to choose criteria and sheet destination.

      5) That should be it, test automation once.


      Ricky T

      Gov Contractor for USSF

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭
      Answer ✓

      You can make an automation to move rows from one sheet to another, Unfortunately it will copy over the other information but you can hide those columns on your second sheet.

      1) Automation is located in top left corner

      2) Create flow from template

      3) Choose " Move a row to another sheet when specified criteria are met" template.

      4) Follow steps to choose criteria and sheet destination.

      5) That should be it, test automation once.


      Ricky T

      Gov Contractor for USSF

      · Share on FacebookShare on Twitter
    • ✭✭✭

      i can definitely make that work! Thank you!

      · Share on FacebookShare on Twitter
    • ✭✭

      This is a great feature, choosing the "Move a row to another sheet when specified criteria are met" template from automation.

      However, I believe it should only copy/move data from Sheet A to Sheet B where the column names match. Currently, it is copying other columns from Sheet A to Sheet B as well.

      Is there any workaround for the same?

      · Share on FacebookShare on Twitter
    • ✭✭✭
      DeepeshSD

      Following this because I have the same question - I do not want to move all rows, only matching column names.

      · Share on FacebookShare on Twitter
    • ✭✭

      As I am also looking for a solution, meanwhile I can suggest two workarounds:

      1. To avoid moving all rows:
        • Create a new checkbox column.
        • Create automation workflow when "Only the rows that are checked need to copied or moved to the destination sheet."
      2. For matching column names:
        • Hide the columns that do not need to be visible in sheet
      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions