Forum Discussion

murali5431's avatar
murali5431
Helper III
6 years ago
Solved

Considering null value date as incomplete

Hi,

 

I have 4 columns of date fields in my dataset. I am trying to build a calculated column which shows status as completed only if all 4 timeline columns have a date entered. 

 

If any one column is blank, it should consider as pending under "Completion status" as shown below. Please assist. Thanks in advance! 

 

Timeline1Timeline2Timeline3Timeline4Completion status
01-Aug-2005-Aug-20  Pending
02-Aug-2004-Aug-2008-Aug-2015-Aug-20Completed
01-Aug-20   Pending
01-Aug-2005-Aug-2007-Aug-20 Pending
05-Aug-2010-Aug-2011-Aug-2017-Aug-20Completed

 

Thanks,

Muralidhar

null value fields
  • amitchandak's avatar
    amitchandak
    6 years ago

    murali5431 , Create a new column like

    if(not(isblank([Timeline1])) && not(isblank([Timeline2])) && not(isblank([Timeline3])) && not(isblank([Timeline4])) , "Completed" , "Pending")

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    murali5431 , Create a new column like

    if(not(isblank([Timeline1])) && not(isblank([Timeline2])) && not(isblank([Timeline3])) && not(isblank([Timeline4])) , "Completed" , "Pending")