Hi Sara, I concur with your approach and Richard's advice, but assuming
that in your Workfront instance "DED" also means that no further changes
are made (or perhaps allowed) to be made to a project, as the Last
Update Date would be "the day it was moved to DED", instead of hunting
down and updating your Field2, you could also consider this formula for
your special Field3, which would then catch those historic delinquents
using that assumption: IF(Status='DED',IIF(ISBLANK{Field1),Last Update
Dat...