Send & link a row to another sheet

Options

I'm wondering if there is a way to send a row to another sheet and link some of the data, but do it in a simple way rather than manually linking.

Background - We manage our projects using the Gantt view which works well for the project team. Some of the tasks then go to a shared creative team who use card view to run sprints.

It would be great to select one of those rows from the project gantt chart and send it to the creative teams' card view sheet while keeping the title and linking the start & end date.

We can currently send a card to another sheet and then manually link the start & end date but this obviously takes time.

Answers