Hello
I have a dataset which has a Summitted date and closed date along with a status. I need to find all the active cases, however a ton of the cases have a closed date, but the status was not updated. Is there a calculation I can create that shows something along the lines of:
If there is a closed date then status = closed
Sounds simple enough. Thanks in advance for your help
1 answer
HI @Angel P
You can try to use this one (in case the field is empty):
IF ISNULL([Close Date])=FALSE THEN "Closed" END
thanks,
Adrian
