Hi everyone, trying my luck here as i haven´t heard back from monday.com´s support team
I have a drop down column with several product options. eg. ProductX, ProductY and so on.
I am then trying to create a formula column that will, give a value depending on what product is selected in the item.
so say an item has “productX” in the dropdown then the function should returns value X.
however if it item has “productX” & “ProductY” the function should return value X+Y
Here is a quick screenshot for what i am trying to achieve. I can use a simple if function for when its only one drop down label selected but as soon as i have more then one i have no clue what to do.