Simulating a filter
 

I would like to simulate a filter based on the contents of a Column similar to the way KGTD does it but I need it to function on multiple columns. The column equals who the task is assigned to on my team. I'd like to have the task duplicated in the same outline. Basically look like this

Project 1 Name Type Project Name
Do item one Tom Call Project 1
Do item two Dave Email Project 1
Project 2
Do item three Tom Email Project 2
Do item four Dave Call Project 2

Call
Do item one Tom Call Project 1
Do item four Dave Call Project 2

Email
Do item two Dave Email Project 1
Do Item three Tom Email Project 2

Tom
Do item one Tom Call Project 1
Do item three Tom email Project 2

Dave
Do item two Dave email Project 1
Do item four Dave Call Project 2

Does that make sense? If so can someone point me in the right direction?

Thanks,

George

So... this should hopefully get you started. Without doing something much more complex, you'll probably need to change the structure a bit and put all projects in a section and then have a section for people and a section for types.

Then what you'd do is check all items in the different projects Some things that could be of use:

[CODE]every row whose (level is 3 and topic of parent is "test")[/CODE]
[CODE]tell (every row whose topic is "test")
set topic of every child to "bingo"[/CODE]

You know how to check the contents of a cell in a row so then you'll want to check if the row already exists in the other section and if not add it. As far as updating entries, would be easy enough to do if the name of the item didn't change, if it does, pretty sure you can do some referencing to match back to the row but that's beyond what I know how to do yet. You could also just erase all the additional sections and have it rebuilt by the script.

That's what I needed, off to the races. Thanks Derek.