Adding task line in one sheet and displaying in/moving to another
I have individual sheets created for 4 people (one being mine) where we have lines for all our tasks. I use a Report to consolidate all 4 sheets.
However, when I have a new task I want to assign, I prefer not to have to access each of their sheets to add a line. I'd like to add the task line on my sheet and assign the Task Owner from there. Then I'd like the line to display in/move to the assigned task owner's Smartsheet. Is there a way to automagically display in or move a line from my sheet to the Task Owners sheet?
Shot in the dark...