Formula for Health based on Week
Hi everyone - I have a Project Plan with an associated Master Tracker & Metrics Sheet. I am wanting to pull in the Health (RYG symbol column) based on the week. An example of my Project Plan is below:
You'll notice I have a "Week (Helper Column)" which helps me with calculating which week a project is at any given time. I'd like to broaden that formula a bit to include the week AND health. An example of what this Master Tracker/metrics looks like is shown below:
So, I'm only tracking one row per client and I need the week and health to be dynamic and adjust based on the start and end dates in the project plan. Any ideas?
Thanks so much in advance!
Help Article Resources
Check out the Formula Handbook template!