Hi,

We have a single – yet very important – business process where the priority of the tickets related to this process must be set using three Additional Fields created as Pick-lists with four options in each. I thought a point-system would be the best option as the Priority of the ticket can be set using simple calculation in an executable field & form rules script.

The Additional fields are set up as follows:

Field1

·         TextString1 (3 points)

·         TextString2 (2 points)

·         TextString3 (1 points)

·         TextString4 (0 points)

Field2

·         TextString1 (3 points)

·         TextString2 (2 points)

·         TextString3 (1 points)

·         TextString4 (0 points)

Field3

·         TextString1 (3 points)

·         TextString2 (2 points)

·         TextString3 (1 points)

·         TextString4 (0 points)

The Priority calculation:

If 0-3 points set priority as Low

If 4-5 points set priority as Medium

If 6-7 points set priority as High

If 8-9 points set priority as Critical

Is something like this a possibility? Are there better options?

Any help achieving the requirement above would be greatly appreciated!