NOELHODGES
2 months agoQrew Cadet
Pipeline Help
We need help building a pipeline for our Overall Status fields that has multiple conditions. We want to grab Overall status based on the criteria given below.
QBID Overall Status | Program Status |
A. If all QBIDs are in Completed status | Completed |
B. If A is false, & if one or more QBIDs are in In Production status, follow these rules based on Overall Status | |
1. If any Overall Status = On Hold | On Hold |
2. If 1 is false, & if any Overall Status = Development Paused | Development Paused |
3. If 2 is false, & if any Overall Status = In Jeopardy | In Jeopardy |
4. If 3 is false, & if any Overall Status = At Risk | At Risk |
5. If 4 is false, & if all Overall Status = On Track or (blank) | On Track |
C. If B is false, & if one or more QBIDs are in On Hold status | On Hold |
D. If C is false, & if one or more QBIDs are in Backlog status | Backlog |
E. If D is false, & if one ore more QBIDs are in Solutioning status | Solutioning |
------------------------------
NOEL HODGES
------------------------------