I am trying to reference two fields and if neither have data then default to a third field. if( not null([category override] default to [category override]. if(notnull([category entered] default to [category entered] if either of the previous fields has any data then I need that in this field. If not the formula needs to reference [category patient ID] Thanks for all your help!!