For more information, please refer to this announcement explaining best practices for getting answers to questions.
Time Intervals for "Req CSW Status"
Content
Hello,
I'm working on a report to show how long a particular req spent with candidates in the various steps/statuses of the CSW. I've been able to assign a "Recruiting Step" to a req based on variables like below:
=If([Req. Current Status (Detail)]="Approved";"Waiting to be Posted";If([Req. Current Status (Detail)]="Sourcing"And([# Applications Currently New]>=1And([# Applications Currently 1st Interview]=0And([# Applications Currently Reviewed]=0And([# Applications Currently 2nd Interview]=0And([# Applications Currently Testing]=0And([# Applications Currently Offered]=0))))));"HR Sourcing and Screening";If([Req. Current Status (Detail)]="Sourcing"And([# Applications Currently 1st Interview]>=1And([# Applications Currently Reviewed]=0And([# Applications Currently 2nd Interview]=0And([# Applications Currently Testing]=0And([# Applications Currently Offered]=0)))));"HR Sourcing and Screening";If([Req. Current Status (Detail)]="Sourcing"And([# Applications Currently Reviewed]>=1And([# Applications Currently 2nd Interview]=0And([# Applications Currently Testing]=0And([# Applications Currently Offered]=0))));"Hiring Mgr Review";If([Req. Current Status (Detail)]="Sourcing"And([# Applications Currently 2nd Interview]>=1And([# Applications Currently Testing]=0And([# Applications Currently Offered]=0)));"Interview";If([Req. Current Status (Detail)]="Sourcing"And([# Applications Currently Testing]>=1And([# Applications Currently Offered]=0));"Background Check";If([Req. Current Status (Detail)]="Sourcing"And([#