Custom Field Formula support for calculations from weighted drop down lists

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.

4
7 Kommentare
Spot On Innovative Approach Stellar Advice
Avatar
Hugh

Hi Stephanie Smith, welcome to the Community!

Thank you for your suggestion here, it's been passed on to the Product team.

2
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi Stephanie Smith and @...!

 

I have a project prioritization matrix that I've recently integrated Wrike (although still rather clunky, but mostly because I'm still hoping for more powerful custom field management tools and sorting/sections options on card view).

 

For my «criteria» fields, instead of being 1-5, I use a percentage field (0-100). Then I have a calculated field that sums all those criteria fields with a weighted multiplier, and I get a resulted weighted score in this calculated field.

 

I'd love to see a weighted calculator option, because some criteria assessments are much better graded 1-5 instead of 0-100, but my work around seems to be OK for now!

 

I think this type of feature is one that goes along with several other discussions around improving project portfolio management within Wrike- Agile boards for projects, more project filtering and widget options for dashboards, availability of calculated custom fields in dashboard widget and report filters.

 

Thanks for the continued work team!

 

 

mdr

2
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Hugh

Thank you for sharing this input, Bernard Hudon!

No update from the Product team at the moment - if there is any new information, I'll be sure to let you know.

mdr

1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

I would love to see this feature as well.  Without custom field validations (in project view), we are getting alpha values in numerical custom fields and it's breaking our report.

1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Thank you for supporting the suggestion and sharing your use-case here Long Ho! Please upvote Stephanie's post above if you haven't already 👍

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

1
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar

We are working through project prioritization automation using values for Impact, Urgency, and Complexity. This feature would be most helpful for our team.

0
Aktionen für Kommentare Permalink
Spot On Innovative Approach Stellar Advice
Avatar
Hello Denise Miller, thank you for adding your support for this idea 😊
 
Please be sure to upvote the original post by clicking on the heart icon if you haven't yet. The number of upvotes a post receives helps our Product team to assess the popularity of the suggestion amongst our members. I'll make sure to let you know if there are any updates 🙋🏻‍♀️

Cansu Community Team at Wrike Wrike Product Manager Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

Cansu Wrike Team member Erfahren Sie mehr über Wrikes leistungsstarke Funktionen und lernen Sie Anwendungsbeispiele kennen

0
Aktionen für Kommentare Permalink

Folllowing List for Post: Custom Field Formula support for calculations from weighted drop down lists
[this list is visible for admins and agents only]

Nach oben
Didn’t find what you were looking for? Write new post