Column to show "0"
-If the task is in the past AND 100% complete
-If the task is in the future and 0% complete
Columns to show result from the following formula;
(DateDiff(Start, Today)-[~LP].ActualDuration)
IF
It is in progress and being progressed.
If the task is in the past with 0% progress it should be showing a value. The difference between today and the start of the task (latest progress)
I hope that gives an indication and enough detail as to the requirements.
I am in a bit of a pickle. Hoping someone could shove me in the right direction. I need the following (regarding slip) Column value to show "0" IF; - The task is in the past AND 100% complete- The task is in the future and 0% complete Column value to show result from the following formula (the bit I could get to work);DateDiff(Start,Today)-[~LP].ActualDurationIF- The task is in progress IF the task is in the past with 0% progress it should be showing a value - the difference between today and the start of the task (latest progress) I hope that gives the detail explicitly enough and hope someone can help out! I am tearing my hair out over this....