Hello,
I have a sheet that lists requests, and I want to write a formula for the Urgency field (Critical, High, Medium, Low dropdown options).
Estimated End Date | Actual End Date | Users Affected | Work Blocked | Users+Blocked | Urgency | Status |
|---|
06/19/26 | 06/12/26 | 15 | No | | | Completed |
06/11/26 | | 17 | Yes | ! | Critical | In progress |
06/15/26 | | 5 | Yes | | Low | In progress |
06/12/26 | | 25 | No | | | On hold |
06/11/26 | | 9 | Yes | | High | Requirements gathering |
06/15/26 | | 3 | No | | Medium | In progress |
06/04/26 | | 7 | No | | Critical | In progress |
The Users+Blocked helper column formula is =IF(AND(VALUE([Users Affected]@row) >= 10, [Work Blocked]@row = "Yes"), "High", "").
The criteria for Urgency setting are:
Critical
- Estimated End Date in the past or today
- Users+Block is ! + Estimated End Date is next working day
High
- Users+Block is ! + Estimated End Date is 2 or more working days from today
- Users+Block isblank + Estimated End Date is next working day
Medium
- Users+Block is blank + Estimated End Date is 2 or 3 working days from today
Low
- Users+Block is blank + Estimated End Date is 4 or more working days from today
Blank
- Status is “Completed” or “On hold”
Using the AI formula builder gets me through about half of the criteria, then errors out. I appreciate any help any formula wizard suggests!
Thank you!
Lori F.
