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.