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
edited Dec 13, 2022 7:02AM in Taleo Enterprise 1 comment


Onboarding Task completed formula


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.


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