Tracking Submissions (Did Not Receive Rejection Letter)
Summary
Tracking Submissions (Did Not Receive Rejection Letter)Content
Hello,
I'm in the process of creating a formula that will tracking how many submissions did not receive a rejection letter. Currently, we have 4 rejection letter templates that are being sent to applicants: Internal, External, After Interview, and Union. Still learning SQL lol!
For example, IF submission ID did not receive Internal, External, After Interview, and Union rejection letter for Requisition XYZ THEN Column=NO ELSE Column=YES
Thanks:)
Tagged:
2