Apr 09 2021 01:31 AM
I added the following custom field with the formula: [Remaining Work] / [Remaining Duration]
Now I want to add an "if" condition, meaning if a task is 100% complete, that no value or the value "n/a" is given.
I found the IIf function is the correct one, but I only get errors with the different ways I have tried to write the formula, e.g.: IIf ([% Complete] = 100, "n/a", [Remaining Work] / [Remaining Duration]) or
IIf ([% Complete] <100, ([Remaining Work] / [Remaining Duration]), "n/a")
Do you have any advise how to use the IIf formula?
Apr 09 2021 05:37 AM
Apr 09 2021 06:05 AM
Dear @Dale Howard, thank you very much for your help!
Unfortunately I can't get it to work, but do you know some resources (books, websites etc.) where I can learn more about how to write formulas in MS Project? I can't find much information online, does there just not exist much information?
Thank you very much for your help!
Kind regards,
Nicola
Apr 09 2021 06:32 AM
Apr 09 2021 08:57 AM
@Dale Howard,
Ismet Kocaman has a book on Project formula creation. It's not free and I don't know the price but I believe it is similar to Rod Gill's book on Project VBA. The link for Ismet's book is:
Apr 12 2021 05:38 AM
@Dale Howard Yes, I copied your formula and also tried typing it in and picking the fields & operators, but it gives me an error message (see screenshot attached).
The difficulty is that it does not indicate where the error is, I tried if a simple IIf formula works, but not even that I can get to work.
So far only the formula [Remaining Work]/[Remaining Duration] has worked on its own (as a number type).
With the IIf formula I want to achieve that the project managers see when a task is complete, so they don't need to pay attention to these tasks when they assess how much work still is to be done in the remaining time for a task. So it does not necessarily need to show "n/a" it could also show something else (like a number or a flag)
Apr 12 2021 05:39 AM
Apr 13 2021 06:13 AM
May 03 2021 06:00 AM
Thank you @Dale Howard ! It worked perfectly! Thank you very much for your step by step instructions!
Do you also know how I can adjust the formula so the summary tasks and parent tasks have an "n/a" as well? (on the picture these are the bold tasks "Phase 1" and "Planungsphase 1")
May 03 2021 06:23 AM
May 06 2021 01:40 PM