Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
are you sur that [Candidate FullName] or [CV Send Date] is null? could it be ''
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.
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')
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
could you post the spreadsheet?