I need to create a calculated field using this logic: # of casesIF status = closed then use the date resolved fieldIF the date resolved is blank then want to use date closed field.
For this, you can write a calculated field with the code like below-
IF [STATUS] = 'Closed' THEN [Date Resolved]
ELSEIF ISNULL([Date Resolved])=TRUE THEN [DATE_CLOSED]