I have a SharePoint list with a completed date column. I wish to have a calculated column called status so when the completed date column has a date in it, it shows "Closed" and when it is blank it shows "Open".
Can anyone help me with the formula for this please?