Forum Discussion
Baseline fallback formula fails in project center
Hi Community, I have multiple projects: some have only a single baseline, some have two (Baseline and Baseline 1), and others have none. Later, I created a new project‑level, date‑type custom field...
I’ve seen this before. The #ERROR usually happens when the field evaluates against an NA date. Also your IIf logic looks reversed for your intent. If you want “use Baseline 1 when it exists, otherwise use Baseline”, try:
IIf([Baseline 1 Start] <> ProjDateValue("NA"), [Baseline 1 Start], [Baseline Start])
Notes:
Make sure the custom field is Project-level, Date type, and uses a formula.
Open each project, calculate, then Publish so the value appears in Project Center.
If it still shows blank in Project Center, check that the view includes this field and that the project has been republished after creating the formula.
For context, I ran into similar calculated-field behavior on my https://altahoorquraninstitute.com/
Thanks!