Reference a Report

I am using a form to track time spent on projects. Right now, they select the project from a dropdown list that I manually created and then they type in the task and the hours worked.

Ideally, I would like for the Task Name to populate according to those available based on the Project selected. For example, if the user selects System Website from the Project list, I would like the Task list to generate all tasks that exist on that Project grid, so they can specifically charge time to a task.

I think that formula might be unwieldy so what I'm thinking is I could create a Report that populates any tasks that aren't marked as 100% Completed. That would pull all tasks from all projects into one sheet.

Is it possible to reference a report, and not just another sheet? It doesn't appear possible.

Find more posts tagged with

Forms

Education

Formulas

Project Management

Cell linking

Comments

Andrée Starå

Hi,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

A possible workaround could be to have the form on one side in a dashboard and the sheet or report on the other and in that way they could see what's available.

Would that work

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

KWright84,

I may have a work around. It would require a little bit of work setting it up, but it will change a displayed list of tasks based on the project selected. As of right now, I only have it displaying the list of tasks. It would still require manual entry of the task itself into a tracker sheet, but at least it would provide consistency of tasks entered along with serving as a kind of searchable database for all tasks based off of the project selected.

Depending on how in depth and complex you want/are willing to get, we may be able to build in some sort of tracking that will show you a total of what has been charged to each task and other pertinent info. That would require a fair amount of work and time though.

KWright84

Hi Paul,

I'd love to hear about the workaround! I'm willing to get as complex as needed to solve this problem and ensure the work being logged is against the specific tasks, rather than just making people write the task in themselves. I'm imagining adding another column to the project page for "Work Hours" which is updated each time someone submits hours against that task.

Paul Newcome

Could you provide an email address I can share a sheet to for you? It will be MUCH easier to explain with actual examples as opposed to trying to just explain here. It basically uses a master sheet of projects and tasks and uses an INDEX/MATCH system to display the correct listing of tasks based on the project selected.

KWright84

katherine.wright@yesprep.org

Paul Newcome

Ok. I will get something to you within the next couple of days.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.