Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Automatically copying a row to another sheet depending on if a certain cell matches the sheet.

Jeff Bortner
edited 12/09/19 in Archived 2016 Posts

I was wondering if there was any way of automatically moving rows of information depending on information found in a specific column. For example. I have one sheet that lists tasks that have been done by employees and the job number that they were working on (i.e. 165-07). I also have other sheets that provide the information for that specific job. I would like Smartsheet to recognize the job number in one sheet, and then place the information in the corresponding job numbered sheet. I realize this is quite the task. Perhaps someone might have a better way of achieving this effect.




  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    Hi Jeff

    This is something that most companies do when the work has been completed and you need to "Send the completed Rows" to eg an Archive sheet. There is no way to do this Automatically in Smartsheet that we have found yet, but welcome innovation? 


    The simplest solution is to sort them into a group, then Right Click "send rows" to Archive sheet. Very easy and simple but not automatic. 

    If you want Automatic you need to use an API link based on a trigger to send those Rows to another sheet. If the volume is high and the benefit worthwhile, it will be worthwhile setting that up. There are several choices for this and happy to review them if you think it worth a little extra cost? 






  • Jeff Bortner
    edited 02/17/16

    Thanks for the info Richard! Any way you could point me in the right direction for creating an API link?

  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭


    Try Zapier first, then if you want more complexity try Azuqua. otherwise... call us and we can discuss. 


    Hope that Helps



This discussion has been closed.