Hi,

I need a formula that can trigger the different project scales based on entered selections.

The main purpose of this exercise is for the Project Managers to identify if the project size is $mall, Medium, Large or Epic depending the predetermined response. I created a Form in SmartSheet application. The form has 5 questions of which each question has 4 option answers to choose from, each option should have a score, then all the response scores will give a grand total Score then that final score will be translated to the word Small, Medium, Large or Epic. What I am looking for is a formula that fills in the score or value of the response selected. See sample below the form Ex No 1 . Sample of the sheet where the data is transferred over for calculations Ex Ex No 1 See - Form below Proiect Nama * Time to complete * Select from dropdown the time this project will take to be done Team Knowledge Base " Select one response Users I impacted/Involved * Select one response Communication * Select one response Team Resources * Select one response Submitter * I have the formula for the sum of the scores : = SUM([Points - Column 1 - Response]@row:[Points - Column4 Response]@row) I have the formula to translate the score to write the project size this same Score can be kept the same I just gave each project size a score of 20 points for small, 40 for medium and so forth: =IF([Total Score]@row >=80, "Epic", IF([Total Score]@row >=60, "Large", IF([Total Score]@row >=40, "Medium", "Small")) Following are the options for each question: Question Num. 1 - Time to complete 13 months 4-6 months 6-18 months over 18 months Question Num. 2 - Team Knowledge Base Use product regularly Know product, lack experience/Use product regularly but not this function Low knowledge of product Do not know product Question Num. 3 - Users Impacted/Involved Non-critical group/ Small group of individuals Critical Group/One Security Group Multiple Group/One Security Group/One Site Multiple/All sites/System Wide Question Num. 4 - Communication No one needs to know Regular update, Acceptance from client required, Follow up with client, redistribute existing documents, assigning existing training Minor training documentation, Team Talk, Process documentation change (BPR) High level of documentation, Generate complex training documentation" Question Num. 5 - Team Resources 1/0 1/1,2/0 2/1 or more 3/0 4/0, A lot of other resources Once the form is submitted the requestor receives and email notifying the Project size with the responses selected in each question see below: I have these two formulas of the value. The value or Points is the formula I need