Hello,
Here's the set up:
I have Four columns I'm working with:
Progress (Drop down menu) [the main option i'm working with is "to do"]
Duration (Duration) [This column is based on how long we have to complete the project]
H# (Number) [This is just a column that takes duration out of days to just numbers]
Allocation % (Allocation) [How much of the work is Allocated to each person]
So basically what I want is when I change the progress column to "To do", I want the allocation % column to display a percentage. The percentage will be 16/(duration)*8
Here's the formula I input: =IF(Progress1 = "To Do", [Allocation %]1 = "16/([H#]18 * 8)")
^^ I've tried many variations of this formula, and nothing works.
Please advise!!
