Custom Formula Fields

N

Nik003

How do you check if a value exists when declaring a formula? For example, I
want to check if [Baseline Finish] or [Baseline Work] exists before using the
values... or even basically to check if a project is baselined or not.

Thanks,
 
B

Ben Howard

Hi, try something like this to check if it has a baseline

IIf([Baseline Finish]=ProjDateValue("NA"),True, False))
 
Top