Forum Discussion
dates
Steve-
Please review the attached worksheet I have added some formulas and notes to the FlowSheet and LeadSch. Unfortunately, the way you have set up LeadSch is prevents an Index Match formula from working. However, I have added a few different formulas that should help get you accomplish your task.
If you don't want some of the values like 1,2,3,4,5 to show in the worksheet you can format them as white font. This way the user doesn't see them....
Hi Mike. I wasn't clear in my previous post. Very sorry. Please see attached. want to create a flow sheet which fills in 'completed by' cell based on which date the job was done. eg job 1 on date 1 was done by someone, job 1 on date 5 was done by someone else, etc. only want to enter date at top to have cells filled in as appropriate. Can you help?
Do you require a result like the following (See attached .xlsx file)?
Sort of like the chart you sent. Here's the thing: I have a worksheet that gives job assignments for a variety of event dates. I have created a second worksheet which reports on everyone's job for a particular date. I want to present reports on additional dates simply by changing the date. If I enter date 1 all the cells will populate with information for that date; another date=other information. I've tried using the following
=if($k$3=datevalue("6-2-2018"),LeadSch!D14,"")
which properly produces the result "Brian". But how to expand formula to include other anticipated dates of 6-9-2018, 6-16-2018, 6-23-2018, and 6-30-2018? I'm assuming that once this is accomplished, I'll just change the dates in the formula for future months. Would I just sequentially add if statements or use if/or?
Hey Steve-
I've extended the range and functionality of the previous file (I adjusted the formula a bit...). Now, I think it will do what you would like. When you change the date in the dropdown it changes all of the names according to the jobs they worked on X date. If this isn't what you would like then no worries. I'll happily take another stab at it. May need a more detailed explanation of what you would like. Perhaps an example file that contains your data structure with a before and after of what you would like would be helpful. If you have multiple workbooks involved then you can just use 1 worksheet to represent each workbook.
Mike, here's the large workbook I'm using LighthouseLdrSchTemp which has several worksheets, two of which are under consideration. LeadSch shows the church leadership schedules for all Sabbaths in June. FlowSheet shows the jobs and assignments for a particular service mostly drawn from LeadSch but some will be just typed in. By changing the date in k3 I want to fill in the necessary names, but I'm such a novice at this that I'm struggling to understand what you have been telling me previously. Hope you are not getting sick of this.