Multiple IF conditions formula doesn't work

Platform discussions
,
1

Hello,

I am trying to write a formula with multiple IF conditions.
Column MONDAY has different values.
Each value can have one specific number attached to it.
The values can appear multiple times. For example - I can have 1000 rows and out of the 1000 rows, 200 can have ‘ABCD’.
With the formula below, only the first occurrence works. It will show the 12-34567-8 across the entire group, however no subsequent IF conditions work and it shows “FALSE” even though ‘EFGH’ and ‘WXYZ’ appear in the column.

IF({MONDAY}=“ABCD”,“12-34567-8”,“FALSE”,IF({MONDAY}=“EFGH”,“09-87654-3”,“FALSE”,IF({MONDAY}=“WXYZ”,“56-78901-2”,“FALSE”)))

What am I doing wrong?

2

Hi @sb123 ,

Try:

 IF({MONDAY}=“ABCD”,“12-34567-8”,
       IF({MONDAY}=“EFGH”,“09-87654-3”,
            IF({MONDAY}=“WXYZ”,“56-78901-2”,
            “FALSE”
            )
       )
 )

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
3

NM, I realized what the issue is (need only one FALSE at the end). Thanks.

4

Thank you @GCavin