Microsoft Teams - Create conditional column - Formula problem?

Question

Hello,I want to create a new conditional column the rule would be: =OR(AND([Material]=120 L Antracite",[Quantity]>6);(AND([Material]=1000 L Yellow",[Quantity]>6));"Ok";"Nok") The problem is when I create my column and I do the test, the latter does not interact.For example, if I create a Material row with "120 L Antracite" and a quantity column of 7, nothing happens.I tested several approaches with basic formulas but it doesn't work, as you can see here:OrThank you for your help :)

Accepted Answer

It seems that there is a problem with the syntax of your conditional column formula. In your formula you forgot to close a quotation mark before "120 L Anthracite", which can cause the formula not to work.

Try this formula:

=IF(OR(AND([material]="120 L anthracite",[quantity]>6),AND([material]="1000 L yellow",[quantity]>6)),"Ok","Nok")

This formula should create a new conditional column that outputs either "Ok" or "Nok" based on the material and quantity column. Make sure you enter the column names in the formula exactly as they appear in your data model.

Once you create the conditional column, the values should automatically update when changes are made to the material and quantity columns.

Create conditional column - Formula problem?

Answers

Related Questions