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....
Try using a formula like the below with some helper cells. It will help you to get to the end result. I'm sure you can incorporate it all into one formula if need be. May get lengthy though. Please see example .xlsx file for reference.
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?
