Allocation percentage disappears
I am setting up a template for project management.
We plan in hours. I have found that the Allocation column will take a formula and have one set up to convert the hours into an allocation percentage based on start and end dates. So far, so good.
I then note that this doesn't work on parent fields. This makes sense, and isn't a problem for my (locked down) parent rows which provide roll up for project structure.
Where I do run into trouble though is that users will be able to INDENT within the parent rows I have set up, making their own parent rows (let's call them level 2 parents, having level 3 children). I have controlled for this in column formula other columns by use of things like ANCESTOR, DESCENDANTS and IF formulae and a helper column showing me the indent levels. But, on the % allocation column the formula plain disappears when a row is indented. The same formula in a row not assigned the job of "allocation" in the project settings works fine, so this is clearly programmed behaviour.
Again, this wouldn't be a big deal expect for the fact that the users CAN allocate hours on a row and then turn it into a parent, essentially becoming a parent row with its own time which then doesn't get included anywhere in the allocations.
So what do I do?
a) ignore it - tell people not to indent rows themselves and hope for the best
b) run a workflow which deletes hours and assigned staff to any row which becomes a parent to scare them out of doing it? (When CHILDREN becomes greater than 1, delete the hours and assigned cell?)
c) set an alarm column to warn them either to remove the time and allocated staff from a parent column or outdent it, coupled with a workflow?
d) ban INDENTING? - I can't see anywhere that this can be controlled.
e) something else?