Calculate Status Based on Date

[utsavlexmark]

Hello,

Can someone help me with some suggestion on how to accomplish the task:

I am working on a dashboard; that is on some courses. The table has a column as "Date of Completion" - it means when someone has completed the course Now I have to create a column as "Status" and it will contain the data whether the course is completed or not. 

If the Date of Completion is there, then the course  is compled and if Date of Completion field is blank the not completed. 

How I can complete this task, please help.

Regards

Utsav

[amitchandak · Accepted solution]

@utsavlexmark , I think you need a new column.

New column = if(isblank([Completion Date]), "Not completed", "Completed")