Automatically Adding Rows Based on Change in Another Sheet

Horace ✭✭✭
edited 12/09/19 in Smartsheet Basics

I would like to be able to automatically populate rows in a sheet based on the change in status in another sheet.

For example, if I have a spreadsheet of jobs I'm bidding on that has a column with dropdown options of "Bidding", "Won", and "Lost", I would like to have a sheet that auto-populates a row in a different sheet whenever the selection changes in the first sheet from "Bidding" to "Won" so that I don't have to retype/re-enter all the info again into the current jobs sheet.

Can this be done?