Nested IF Formula -> Dropdown menu

Platform discussions Special workflows & use cases
1

Hey all,
Looking for some guidance on a nested IF formula.

I’ve got a labels column with about 20 labels. Im attempting to populate the amount in this column for a dropdown option if the selected option is chosen. I am getting returned value of 0 in my column, but not the amount when the label is chosen. It worked when i was only using 2 options, but we have others we need to account for.

Any help is appreciated!

IF({Discipline#Labels}=“MPFPS”,{Amount},0,IF({Discipline#Labels}=“MEPFPS”,{Amount},0,IF({Discipline#Labels}=“MEPFP”,{Amount},0,IF({Discipline#Labels}=“Fire Alarm”,{Amount},0,IF({Discipline#Labels}=“Fire Protection”,{Amount},0,IF({Discipline#Labels}=“Fire Sprinkler”,{Amount},0,IF({Discipline#Labels}=“FP”,{Amount},0)))))))

Screenshot 2024-08-28 092445
Screenshot 2024-08-28 092445813×512 30 KB

2

Hi Jennifer,

If you want {Amount} whenever a dropdown value is selected and 0 if not, then this should work:

IF({Discipline},{Amount},0)

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.

3

Hi @GCavin,

I want to display an amount only when specific disciplines are added, not just any discipline. I have this as part of a larger workaround for divvying up to show on a parent item.

4

Hi @JTruppa,

Then try:

IF({Discipline}="MPFPS",{Amount},IF({Discipline}="MEPFPS",{Amount},IF({Discipline}="MEPFP",{Amount},IF({Discipline}="Fire Alarm",{Amount},IF({Discipline}="Fire Protection",{Amount},IF({Discipline}="Fire Sprinkler",{Amount},IF({Discipline}="FP",{Amount},0)))))))

Or even simpler:

IF(OR({Discipline}="MPFPS",{Discipline}="MEPFPS",{Discipline}="MEPFP",{Discipline}="Fire Alarm",{Discipline}="Fire Protection",{Discipline}="Fire Sprinkler",{Discipline}="FP"),{Amount},0)

Hope it helps

What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.

1 Like
5

@ga that did the trick! I will say this formula will only return one drop option, not if there are multiple options. :slight_smile:

Thanks so much!