Calculation: Populate Nested Values List from Standard Values List
Is it possible to populate the second level of a nested values list from the items selected in a standard values list? For example, I have a standard values list with the following possible values: "red", "blue", "green". I have a nested values list where the top level has a possible value of "color", which itself has possible sub-values of "red", "blue", "green". If the standard values list currently contains the values of "red" and "green" can I configure the nested values list as a calculated field that can copy in the values from the standard values list and put them under the top level value of "color"? In other words, after the calculation the nested values list would contain "color: red, green".
- calculated field
- Community Thread
- Forum Thread
- RSA Archer
- RSA Archer Suite
- Tips and Tricks
- values lists
I created a test app earlier with the following calculation:
This calculation works and correctly populates the Nested values list with "Color: Red, Blue". If I had just a few possible values, I could test for them and concatenate within the formula to correctly populate the nested values list. Unfortunately, the number of possible items in the production system is fairly large and dynamic. So, I was hoping to insert the data directly into the sub-level under "Color" of the nested values list from the standard values list without needing a series of IF statements.
Unfortunately William a long list of IF statements is the best way of doing this. Granted it an administration nightmare to constantly update the calculation when new values are introduced.