Hi,

I am trying to create of conditional formula so if the target date is greater that today then the field should be 'Overdue' otherwise it should say 'Not Yet Due' I have the following

IF(Revised_Audit_Deadline__c > Today(),'Overdue','Not Yet Due')

I get the following error message: Error: Formula result is data type (Text), incompatible with expected data type (true or false).

The data type of the field is set as Picklist, so I am not sure if this would be a problem.

I would appreciate any help on this.

Thank you