If formula with AND and OR

Platform discussions Special workflows & use cases
1

I am creating a formula column to populate it with data already in one of two columns. There are three conditions that would cause the data to be from one of the specific columns; otherwise, it should come from the other column.

  • Condition 1: If the Group Name column status is “Faster,” then the data should come from the “Annualized Savings” column.

  • Condition 2: If the Group Name column status is “Cheaper,” AND the item Name is “Annualized Cost,” then the data should come from the “Annualized Savings” column.

  • Condition 3: If the Group Name column status is “Cheaper,” AND the item Name is “Paper Savings,” then the data should come from the “Annualized Savings” column.

If none of the three conditions are met, then the data should come from the “Process Savings” column.

I’ve tried a number of variations of formulae, but I keep getting an “Illegal Formula” error. Here is my current attempted formula:
IF(OR({Group Name}=“Faster”, AND({Group Name}=“Cheaper”,{Name}="Annualized Cost), AND({Group Name}=“Cheaper”,{Name}=“Paper Savings”),{Annualized Savings}),{Process Savings})

Any help would be greatly appreciated!

2

Hi Jeffery,

Without testing anything, I believe you have a closing parenthesis in the wrong spot. The one after {Annualized Savings}, should be after “Paper Savings” as this is the closing parenthesis of OR(

I would try:

IF(OR({Group Name}=“Faster”, AND({Group Name}=“Cheaper”,{Name}="Annualized Cost), AND({Group Name}=“Cheaper”,{Name}=“Paper Savings”)),{Annualized Savings},{Process Savings})

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.

1 Like