Script

[#1]

Hi All

i want to a submission status list to show the list of the following: "submitted","to be submitted" and not submitted

I have this script that is suppose to do the above but is showing only the "submitted" and "to be submitted"

if([CV Send Date]=[Closing date] ,'Submitted'

  , if( (  [Closing date] < Today() )and( IsNull( [Candidate FullName]) ) and (IsNull([CV Send Date]) ),'Not Submitted' 

   ,  if([Closing date] >= Today() , 'To be Submitted' ))) as [Submission Status]

Thanks and Regards

Priscilla

[syukyo_zhu]

Hi,

are you sur that [Candidate FullName] or [CV Send Date] is null? could it be ''

[#3]

Yes there are fields that are empty in the spread sheet so if candidate name is empty it means the CV was not sent and that make the CV sent date empty.the closing date is always there.

[maxgro]

sometimes you have to replace the IsNull

with len(trim(field))=0 to ckech for empty values

example

if(len(trim([CV Send Date]))=0, ' CV is null', 'CV is not null')

[#5]

this one is working well but it is returning wrong value instead of 40 it is returning 39

if( ( len(trim([Candidate FullName]))>0),'Submitted'

the number of candidates names are 40 in the spread sheet but its returning only 40

[maxgro]

could you post the spreadsheet?