CarolMcconnell
5 months agoQrew Captain
Formula Date Field
I have a formula date field and this is my formula:
If (not IsNull([Date ReOpened]) and ([ReOpened Reason]="Mishandled"),[Date ReOpened],"")
I get an error on the last "" expecting date but found text.
How do I tell it to do nothing if the the formula is not true?