Hi all,

I am attempting to run an automation on a service request item that will calculate 3 different fields based on the responses to other fields in the service request and then provide a response. These fields are hidden to the requester and are filled out by our team upon receiving the request. They contain a combination of numbers and words that explain the values. I then need the 3 fields to calculate the following expressions:

Field 1 + Field 2 = Field 3 → populate field 3 in service request form
Field 4 x Field 3 X Field 5 = Field 6 → Populate field 6 in the service request form

I then need to use the value from field 6 to provide a ranking based on the value range. 

<35 = Low

36-95 = Medium

96-199 = High

>200 = Critical

How can I create a workflow that carries out all of these actions at the same time, once the values have been updated by a team member working on the service request item?

Thank you all in advance for your ideas!