question

NicolaEberhard-0146 avatar image
0 Votes"
NicolaEberhard-0146 asked DSPatrick answered

IIf formula in microsoft project custom field

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")

not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Office project is not currently supported here on QnA. The product group for Project actively monitors questions over at
https://techcommunity.microsoft.com/t5/project/ct-p/Project

--please don't forget to Accept as answer if the reply is helpful--




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.