Can I use a form with prioritization formulas?
I am trying to come up with a more simple way to prioritize projects in my organization with one way to input a project. When a user wants to input a new project into the portfolio, they would use the form to select answers related to the project. When an answer is selected, it has a certain value and weight attached to produce a score. Ideally, we are trying to have the score automatically updated with each form entry so we can keep track in a master list. Currently, we are using a basic excel model to produce a score and then manually transferring the data and the score over to SmartSheet. Any help would be appreciated! Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!