Populating data into another sheet when certain criteria is met

monica.wood1998

I have two sheets that I need to work together - one for project tracking and one for expenses. When I change the "Payment Status" on an activity within my project tracking sheet to "paid", I want specific data from the row of that activity to populate as a new row in my expense sheet. The expense sheet should contain both auto-populated entries from the project tracker sheet and also manual miscellaneous entries. Could anyone help me configure this? Here are my exact sheet and column names:

Sheet 1: "South Central - Project List"

Columns from sheet 1 that I want to populate into sheet 2:

"Activity Name", "Category', "MDF Amount ($)", "Partner", "Account", "Actual Spend ($)"

Sheet 2: "South Central Expense Tracker"

Paul Newcome

Using the core product, you would have to copy the entire row using a copy row automation. Any columns not needed though could be hidden to prevent clutter.

If you have access to the API, the premium add-on Bridge, or another similar third party app, you would be able to configure specific columns being copied.