Pulling cell data based on date and name
Could someone help me with a bit of a pickle I can't get around?
I have a sheet with multiple dates and names and their daily progress. The dates are pre-populated for the entire month with everyone's names assigned for each day. I've been trying to figure out how I can extract the status percentage for a specific individual and today's date so that I can use that cell as a metric on the dashboard, displaying the progress for the current day. Any thoughts?
Help Article Resources
Check out the Formula Handbook template!