I'm trying to duplicate something I had previously been managing in Excel. Basically, I have 5 different fields, that all have an option with an associated weighting: Example, development time (field name), options: low - 5, medium - 3, high - 1. So with these 5 fields similar to the one mentioned above, I want to do a multiplication of all of them together to determine a new value, that will be the Priority Weighting (custom Formula with conditional color options).
I would like to request the following features to be added to support the above:
- Allow adding a number weighting to drop down list items (option + number weighting). Additionally, allow a definition for each drop down item. (i.e., item name: low, item weighting: 5, definition: 0-6 months).
- Allow the custom Formula field to do multiplication on these drop down list weightings (currently you cannot create ANY formula based on a drop down list, even if you enter numbers into it - it will only allow you to use a number field).
I am getting by right now by having 5 separate number fields in Wrike (but having to still use Excel for the drop down with weighting option as a reference, to manually enter the resulting number to Wrike), and using a custom Formula in Wrike to multiply the manually input numbers and highlight with conditional color.
The reason I would like this capability is the Priority Weighting is evaluated for each project. To be able to seamlessly evaluate this in Wrike would be ideal.