Dropdown item formula to return one or more labels

Platform discussions Special workflows & use cases
, ,
1

Hi everyone, I’ve been searching throughout this helpful community and tried multiple formulas without success.

  • I have a drop down column with multiple options, labels corresponding to various hotels (‘Property’) in the market.
  • I am trying to create a formulas column that will return label(s) depending on what the ‘Property’ column includes.
  • One formula column to display which neighborhood that ‘Property’ is located.

IF(OR({Property#Labels}=“ARIA”,{Property#Labels}=“Caesars Palace”),“Strip”,“”)

  • Another formula column to display the hotel operators of that ‘Property’

IF(OR({Property#Labels}=“ARIA”,{Property#Labels}=“Bellagio”),“MGMRI”,“”)

The issue I’m running into is when I have more than one label selected in the Dropdown column, the formula column returns empty.

My end goal is to create a Data tab with a chart that will tally total # of hotels (‘Property’) and then charts tallying total uses of neighborhoods and hotel operators.

2

Hi @RamonMontez,

Try:

IF(OR(SEARCH("ARIA",{Property#Labels},1)>0,SEARCH("Caesars Palace",{Property#Labels},1)>0),"Strip","")

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.