Friday, November 9, 2012

yogi_Get Names For Weekly Task Assignments For Specified Activity From A Date_Name_Activity Table


                                           Google Spreadsheet   Post  #864
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 09, 2012
user awyatt said : (http://productforums.google.com/forum/?zx=sa5238gcjnz7#!mydiscussions/docs/36sZR3-VR24)
the solution in this post supplements the solution I posted in response to a question by user a wyatt in my following blog post:
yogi_Delineate Names For Weekly Task Assignments From A Date_Name_Activity Table
http://yogi--anand-consulting.blogspot.com/2012/11/yogidelineate-names-for-weekly-task.html
---
https://docs.google.com/spreadsheet/ccc?key=0AhJ53dneUaMIdENXeHBPN1dIMlItNkZBRWYyRGNQcWc

there's the link for the working copy i'm messing with. the top is the automatic version with your formulas in it. i included a snapshot (fully manual) of what it would look like in the end

the ultimate goal in this case is to include names in the filter ONLY if the person walked the dog. thus in the manual copy at the bottom you see only three names entered, because the other entries did not walk the dog

does that help you enough? i know my explanations can be convoluted sometimes!

----------------------------------------------------------------------------------------
following is the solution to a bit more generalized problem in that one can specify the Activity for which the Name(s) need to be pulled for Weekly task Assignments

No comments:

Post a Comment