Work out when 2 different priorities each with different baseline points, will match up

meera_lynn Something like this?

I think having a table to compare is neither here or there - it'd probably be easier using a dropdown (included) or using the same formula you could do a lookup table / function for each person on hold to consider how many "points" they have.

I do think that the x10 aspect of points is kind of arbitrary though, it might be worth doing some research into how much extra weight you apply per tier.

Edit: I provided a table because I misread the question, whoops. I'm pretty sure your table is so simple it'd be a case of "have they been on hold for 100x less" for high to normal, etc.