Add feature to create pre-defined option sets with name value pairs for use with single select and multi-select option fields
Problem Statement:
At times, there may be a need to display a list of options to a user that are presented differently than the underlying value that is stored. Sometimes, this is a rating scale like Low, Medium, High that might have numeric values that are stored as 1, 2, 3. Other times, it may be a list of states or provinces that are presented as the full name but stored as an abbreviation. Option sets may also be desired to use across multiple fields.
Proposed Solution:
Add a feature to allow defining option sets that can be used to create name value pairs of differing data types. Allow single and multi-select option fields to use a defined option set. Allow admins building forms and reports that display these to choose which value should be shown - the underlying stored value or the display value. Allow conditional formatting and calculations based on the stored value of the option set used for a field. e.g. Allow averaging the underlying numeric score of a Low, Medium, High option set field.
This would be great! We are currently implementing a company wide request process where we want the requestor to select from a list where the list options are descriptive, but only store the numerical values so that we can run formulas and such on them.
Hi Phillip Ushijima, thanks for posting your suggestion, and Ashley Fischer, thank you for adding your support! This post is now being forwarded to the responsible team. If there’s any update on this topic, I’ll make sure to post it here.
Rohan V Community Team at Wrike Wrike Product Manager Infórmate sobre las funciones y prácticas recomendadas de Wrike
Rohan V Wrike Team member Infórmate sobre las funciones y prácticas recomendadas de Wrike