Forum Discussion

murali5431's avatar
murali5431
Icon for Helper III rankHelper 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 col...
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")

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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")