How to pull in row data from Sheet 1 into Sheet 2 if two criteria are met

Jessica d
Jessica d
edited 02/27/23 in Smartsheet Basics

Hello,

How would I pull in row data from Sheet 1 into Sheet 2 if two criteria are met:

  • Column A is checked
  • And team = TeamName

Thanks

Answers

  • Lucas Rayala
    Lucas Rayala ✭✭✭✭✭✭

    Hi @Jessica d, that depends on what you mean by "pull in row data" -- are you looking to transfer an entire row? You can do that via either an automation or DataMesh (if you have the correct license). An automation would require that all your columns in your source sheet have corresponding columns in your destination sheet with matching column names. DataMesh is more flexible.

    If you just want pull data from one cell to another cell, say from Column B in your source sheet, then you would use this formula in your destination sheet:

    =INDEX(COLLECT({Column B}, {Column A}, 1, {Team}, "TeamName"),1)

    Feel free to expand a little on what you're looking for.