SharePoint list - how to fill a cell when another is emtpy or not

[cAhler]

Hello,

I have a Sharepoint list with a column "IBAN" and another column "Partner". Now I would like to ensure that if there is something in the "IBAN" column, "YES" is automatically entered in the "Partner" column. If the entry in the IBAN line is empty, then "NO" should be entered.

Any Idea?

[#2]

@cAhler Create a calculated column called Partner and add the following formula:  =IF(IBAN="","NO","YES")

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

[#3]

@Rob_Elliott 

Sorry, but where i have to set the formular? I still get an technical error.

Thanks

[#4]

@cAhler 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

[#5]

@Rob_Elliott hmm... What's going wrong?

[#6]

@Rob_Elliott

It's crazy, in office 365, SharePoint List i have to use this:

=WENN(IBAN="";"No";"Yes")

Maybe a language problem.