Hi All,
I have attached a workbook here, but this post is only interested in Worksheets 1 ("Tracker") and 2 "("Pipeline).
Basically, "Pipeline" pulls ID#s into one of the 4 colored boxes by their group status ("Pending" for the first group, "Consented" for the next group, etc).
You can see what that looks like in Pipeline! here:
16-282 Study Tracker and Accrual 2016.08.17.xlsm
However, something happened (literally no idea) while I was working, and next thing I know - Pipeline! is drawing blanks:
16-282 Study Tracker and Accrual 2016.08.23.xlsm
Can anyone help me figure out why the function stopped working? I don't believe I've changed any reference rows/columns.
Alternately, I could ask if someone could just help me figure out a new formula that would work.
Thank you in advance to the many talented people on here.
-AW
Bookmarks