Forum Discussion
sandrosg
Feb 04, 2023Copper Contributor
Dropdown List with "description" and actual "value"
Hi there, I'm facing an issue with a dropdown list/menu. I need to create a simple KM calculation. However the KM(value) need to show its description (characters) in the dropdown menu. Any chanc...
Riny_van_Eekelen
Feb 04, 2023Platinum Contributor
sandrosg Another work-around could be to use TEXTJOIN to create the drop down list as "A to B; 20" etc., as shown in G6:G8,
And then you can use a not too complicated formula (G13) to SUM the values from the selected tracks.
sandrosg
Feb 04, 2023Copper Contributor
Hi Riny, this comes pretty close to my challenge. Is there any way to display just the numeric values in 1 cell ?I guess then it's getting more complex...anyway thx so far...