Help to create the formula to take a row data from a sheet, and bring to the main sheet

Options

I have a form that take users data. I need to compare a column data from this sheet with the main sheet and if match bring all row to the main sheet.

Answers

  • dojones
    dojones ✭✭✭✭
    Options

    Use the Move a Row to Another Sheet workflow. Create the column formula that defines when the workflow should trigger. Something like this.

    IF ([column1]@row = {column2}@row, "Match", "")

    Then use the workflow with criteria when the cell is "Match", then the workflow will move the row to the sheet you define.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!