We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Help With Onboarding Formula

Received Response
25
Views
1
Comments
edited Aug 12, 2016 1:52PM in Reporting and Analytics Taleo Enterprise 1 comment

Summary

Onboarding Task completed formula

Content

I was hoping someone could help me create a formula. Every time I try, I keep getting duplicate rows for each candidate so I am obviously missing something.

We have a Pre Hire Process that contains 3 Task including an Offer Letter task. When all tasks have been submitted, the system creates the Offer Letter PDF. If the candidate does not complete all tasks within 5 days, the process automatically completes without a PDF and the recruiter is notified that they can reject the candidate.

What I want is the following:

A list of candidate names who had the pre-hire process started and then I want a column to show a 'Completed' if that particular Offer PDF task was created, else Not Complete. I tried to use the below but it seems to show Completed and Not Completed for each candidate in my list. What am I missing, or is there a more efficient way of accomplishing this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!