null value fields
1 Topic
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! 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, MuralidharSolved1.1KViews0likes2Comments