can i auto-populate/create rows on another sheet if a cell on another sheet changes?

leoc

In this case, I'll populate a scheduling sheet as seen on top, this will then ideally show up on the 18th of Dec (if it's scheduled on the 18th) as separate rows if possible. Not sure if smartsheet is able to do something like this so would like to get possible help or input?

So far i've tried using smth like

=IF(OR(CONTAINS("Truck In", {xxx1}), CONTAINS("Replacement", {xxx1}), CONTAINS("Truck In/Out", {xxx1})), INDEX({Date}, MATCH("Truck In", {xxx1}, 0)), ""); which does update ONE cell but it doesn't work when I apply it to the 2nd column because my truck schedules are all in columns but in one row im assuming it doesn't create more rows