I am looking for an Excel expert to help finish the Master Job Tracker spreadsheet I am building for my company. I have made the headings and have an explanation for what I want each cell to do. We are a court reporting company so we follow each job from the first stage of the reporter writing on her machine the job (transcript), the transcript then goes to a scopist (editor), then to a proofreader, then back to the reporter, and then to the office. You can see why we need to track them! What makes it complicated is there is different turnaround times to select from (5-8 day turnaround, 3-day, same-day). And what I would like to happen is after the job date is selected, the turnaround time, then I would like the 'Scoping Due Date' and 'Proofing Due Date' to auto populate to their respective dates. So for example: If 'Job Due Date' is Monday, then 'Turnaround time' selected is 5-8 days, then I would like 'Scoping Due Date' to auto populate to noon 5 business days after the column 'Job Due Date'. And then I would like 'Proofing Due Date' to auto populate to noon 7 business days after 'Job Due Date.'
Is this possible? I am uploading the initial documents I created, the Excel with column names and a Word document with more explanations about each column.
Thanks in advance!
About the recuiterMember since Mar 14, 2020 David Crone
from Central, Uganda