IF statement doesn't work, it throws syntax error

Question

Hi everyone.

I am trying to create a simple formula for a new column in my SharePoint list.

I was inserting many different forms but it throw the same error each time (and yes, there is a space between 's' and the square bracket in 'Actual status ]')

I tried to find the solution but it seems that noone was able to help yet.

=JEŻELI(NIE(CZY.PUSTA[Change status]); [Change status]; [Actual status ])

=JEŻELI(NIE(CZY.PUSTA[Change status]), [Change status], [Actual status ])

=IF(NOT(ISBLANK[Change status]); [Change status]; [Actual status ])

=IF(NOT(ISBLANK[Change status]), [Change status], [Actual status ])

The error in the last screenshot says "syntax error or the formula is not supported"

Any advice would be vital as this is a key to successfuly finish the project I am working on.

[PII is removed by forum moderator]

Answer 1

Hi Tomasz，

May I know if you received the reply? Feel free to post back if you need further help.

Thanks,

Tina

Answer 2

Hi Tomasz，

Welcome to community.

I go through the post carefully. It seems like you are creating formula in a calculated column in a SharePoint list and it throws an error "syntax error or the formula is not supported".

For this formula you have created:

=IF(NOT(ISBLANK[Change status]), [Change status], [Actual status ])

When I test it from my side, I can reproduce the same error message as you mentioned. I'm afraid this formula do have syntax error.

The formula NOT(ISBLANK[Change status]) will return TRUE or FALSE. That means the IF formula will be like

=IF(TRUE, [Change status], [Actual status] ) or

=IF(FALSE, [Change status], [Actual status] )

I'm afraid it's not a correct IF formula. IF formula's syntax is

IF(logical_test, value_if_true, value_if_false)

For "logical test", it's the condition you want to test. You will need to clarify the condition, not just put the value "TRUE" or "FALSE".

In the meantime, to better understand the situation and help you, could you please also confirm information below?

1.Please share a screenshot of your SharePoint list.

2.Please also share more details about what you want to achieve by using the calculated column.

Many thanks for your time and effort.

Hope you are keeping safe and well.

Best Regards,

Tina