Formula in IF

maxtla

Hi,

I have a problem, I create several formulas with IF, but even if they are the same with different conditions. I still have the same problem in "Logistics" please have a look and let me know what is wrong in the formula. Will appreciate very much your help.

I still have in the SI Competitiveness Program2 the word "Logistics" even if the same formula for other fields are working.

Why in the Data Preview are al formulas Logistics and the one with the Logistics formula is Yes?

tricky....

OllieClarke

@maxtla 

Formulas are applied in order going down the formula tool. The data preview window shows the outcome of the formula for the first row. 

The reason that on the penultimate formula the preview reads 'logistics', whereas it reads 'yes' in the final one is that (and I'm assuming the content of your other formulas here) you only update the column to read 'yes' when the column is 'logistics' in the final formula. This means that the first row will be 'logistics' for all prior formulas before the final one. 

It is very hard to diagnose problems just with screenshots though. If that doesn't help, then please can you provide what your data looks like (can be fake data) and what your desired outcome is and then it's much easier to help.

Ollie