IF Formula doesn't work

Anna Pelipas

Please help, what's wrong?

It couldn't be parsed...

=IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4); ([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4));"ДА";"НЕТ")

Thank you in advance.

Brian Campbell

Hello Anna,

I am having a bit of trouble reading some of it but try switching the ";" for "," see below

=IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4),([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4)),"ДА","НЕТ")

Anna Pelipas

Michael, thank you, it worked!

Brian Campbell

Awesome, happy to hear it.

Anna Pelipas

Oh, no, it was wrong formula I was responding on, sorry. This one still doesn't work.

The meaning of the formula is to put YES (ДА) if first parameter is not equal to 2nd and/or if 3rd is less than 4rd.

Anna

Anna Pelipas

sm_y-n.jpg

Brian Campbell

Try this I think I forgot a parenthesis

=IF(OR(([Исполнитель (из первичной)]4 <> Исполнитель4),([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4)),"ДА","НЕТ")

Anna Pelipas

Still UNPARSEABLE... I'm stuck with it...

sm_y-n.jpg

Andrée Starå

Hi @Anna Pelipas

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Anna Pelipas

Hi Andree.

Did it. Thank you in advance for possible help.

The formula is in the last column.

Anna

David Joyeuse

Hi @Anna Pelipas

In your formula:

=IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4); ([Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4));"ДА";"НЕТ")

You get some parenthesis wrong, hence the UNPARSEABLE. It should be like this:

=IF(OR([Исполнитель (из первичной)]4 <> Исполнитель4; [Стоимость работы (с НДФЛ) (из первичной)]4 < [Cтоимость работы (с НДФЛ)]4);"ДА";"НЕТ")

That one should be working.

Watchout for ";" and "," depending on the language version of Smartsheet you are using.

Hope it helped!

Andrée Starå

@Anna Pelipas

Excellent!

I've already fixed it for you!

Did it work as expected?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Anna Pelipas

@Andrée Starå

Wow! You are the magician, it works! Thank you so much for your help and support.

Anna

Andrée Starå

@Anna Pelipas

Haha!

You're more than welcome!

🧙‍♂️

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!