Forum Discussion
Baseline fallback formula fails in project center
Knowledgeseeker,
You shall seek and you shall find.
Your formula is a little bit backward and the fields have an extra space. Try this:
IIf([Baseline1 Start]=projdatevalue("NA"),[Baseline Start],[Baseline1 Start])
This works in Project Pro desktop. I can't speak to Project Center since I don't use PWA.
John
- KnowledgeseekerSep 01, 2025Brass Contributor
Thank you for taking the time to reply to me. My formula is in French, so the one I shared was actually a translation of the French field names.
Even after changing the fields as you suggested, nothing appears.
What I find most strange is that even when I keep only [Baseline Start] in the formula, nothing is displayed.
- John-projectSep 01, 2025Silver Contributor
Knowledgeseeker,
Let's see your formula in French, maybe I can pick up something.
What exactly do you mean about keeping only Baseline Start? When you say nothing is displayed are you talking about In Project Center or Project desktop?
I'd like to see a screen shot of a typical task line with Baseline Start and Baseline1 Start and the Date field you customized with the formula.
John
- KnowledgeseekerSep 01, 2025Brass Contributor
Hi John-project,
Thank you for taking the time to reply to me. My formula is in French, so the one I shared was actually a translation of the French field names.
Even after changing the fields as you suggested, nothing appears.
What I find most strange is that even when I keep only [Baseline Start] in the formula, nothing is displayed.