Considering null value date as incomplete

[murali5431]

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! 

Timeline1	Timeline2	Timeline3	Timeline4	Completion status
01-Aug-20	05-Aug-20			Pending
02-Aug-20	04-Aug-20	08-Aug-20	15-Aug-20	Completed
01-Aug-20				Pending
01-Aug-20	05-Aug-20	07-Aug-20		Pending
05-Aug-20	10-Aug-20	11-Aug-20	17-Aug-20	Completed

Thanks,

Muralidhar

[amitchandak · Accepted solution]

@murali5431 , Create a new column like

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

[murali5431]

Thanks a lot... @amitchandak