CarolMcconnell
28 days 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?
"Silence is golden". You don't have to say anything for the alternative, and it will just become null. You also had extra parentheses, but while that doesn't hurt, it just adds clutter.
If (not IsNull([Date ReOpened]) and [ReOpened Reason]="Mishandled",[Date ReOpened])
but if that bothers you, you can also do
If (not IsNull([Date ReOpened]) and ([ReOpened Reason]="Mishandled"),[Date ReOpened],null)