How to Find the Furthest Status
I have 2 sheets. 1 with all my active job orders, 1 with all active job applications.
I want to create a column on the job report to represent the furthest active application
I have a job called "Accountant" on the Job Order sheet. The ID# is 1234
On the application report there are five applications with a Job ID of 1234. Three are in a status of "New", one is "Interviewing" and one is "Offer".
How can I create a formula that pulls in the status of the furthest application to my job order sheet for each JobID? In this case the Account job order would have a "furthest Status" of "Offer"
I've decided the weight of each status. I'll likely need to create a column on the application sheet to convert the status to it's assigned weight using an IF statement. But don't know where to go from there.
Help Article Resources
Check out the Formula Handbook template!