Forum Discussion

utsavlexmark's avatar
utsavlexmark
Helper III
5 years ago
Solved

Calculate Status Based on Date

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

Need Help
Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    utsavlexmark , I think you need a new column.

     

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