OK, so if there is a better way to do this than what I’m doing I would love to know.
I’m trying to organize a Todo list first by date, then by group, and then the Todos(see attached Image).
Date
Group
Todos
Groups
Todos
Date
Group
Todos
I currently have the first RG setup with a source of todos grouped by date.
Then I have inside that another RG todos grouped by Groups. This time I had to add all the constraints as the date, but this time I’m doing Due date based on the Date of the parent RG. This works although I wish there was a better way to do this. Seems like a lot of extra searches when if there was a way to just say with the parent’s groups restraints.
The last one is where I run into problems. I’m doing the same constraints again, this time using the parent Group as a constraint. I also want it to be constrained by the date, but it won’t let you do Current Cell’s Current Cell’s Date. It only lets you go back one level of RG. So the todo’s end up showing all the todos in that group.
Anyway I can set this up to work better?
