Hello board,
I have a project in which I'm tracking clients who, at any given time, will fall into one of four phases of the project: Pending, Eligible, Enrolled, and Completed.
I have a formula table set-up that uses input dates to calculate which phase (Pending, Eligible, Enrolled, Completed) a participant is in at a given time, and then assigns one of the four phases in Column F based on these calculations.
Attachment 455734
What I want is to generate a table with four columns - one for each phase - beneath which Excel will send the ID's. Ideally, the columns of this new table would update if a client changes phases. Something like this:
Attachment 455739
I do not believe that VLOOKUP, for example, can perform this task. Any help would be greatly appreciated.
Sorry for redactions in shared images.
Bookmarks