Move Row to New Sheet

I'm trying to figure out how to move a row that contains "New Trip Report" when a new row is added containing "Corrected trip report" and the Report ID's match.

For example: see screen shot. Adding row 2 containing Report ID TR00001TX115 would trigger moving row 1 to a new sheet.

If anyone knows how to do this, please let me know.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!