Forum Discussion
Input forms for a single cell
Is it possible to have an input form for a single cell?
So what my requirement is that I need to collect the number of hours that we've worked on a project. I need a sum of all the hours spent by my co-workers separately in different cells. But I want that sum to have different parts which can be tagged
so basically if a cell value is 8
then 8= 2(production) + 2(brainstorming) + 4 (meeting & discussion)
So, I want the cell to display "8", but I'd like to know the different parts that all sum up to 8, and what those different parts are specified for. So an input form with those parts was my idea.
I know this sounds pretty confusing, but I'd like to know if there's any other way possible.
3 Replies
- I would enter each type of work as a separate row or have a tabe which has a separate column for each type of work so you can add them.
Yeah, I agree, but we already have a template where we categorized different task(parent tasks) to calculate the hours. And this is referred for an overall usage in the office.
But for few projects, we need to separate hours for sub-tasks as well, so I need to find a way that can extract data from the parent tasks into the sub-tasks. Like mentioned below, if I enter 8 in parent tasks for the overall office usage I need that data to be reflected in local(project) usage as different tasks.
- I understand. Given that I still think you would need to input the information into separate cells, be it extra columns or rows.
