Figured it out! I found a similar post from Doug that was about project planned completion dates. I was able to tweak his code and got this: IF(Status='NEW',IF(ISBLANK(Original Due Date),Planned Completion Date,Original Due Date),Original Due Date) Kirsten Heikkinen Trek Bicycle Corporation