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!