Forum Discussion

Copper Contributor

Sep 12, 2023

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

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 "...

Silver Contributor

Sep 12, 2023

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)

cAhler

Copper Contributor

Sep 12, 2023

Rob_Elliott

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

Thanks

Rob_Elliott
Silver Contributor
Sep 12, 2023
cAhler

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)
- cAhler
  Copper Contributor
  Sep 12, 2023
  Rob_Elliott hmm... What's going wrong?
  - cAhler
    Copper Contributor
    Sep 12, 2023
    @Rob_Elliott
    
    It's crazy, in office 365, SharePoint List i have to use this:
    
    =WENN(IBAN="";"No";"Yes")
    
    Maybe a language problem.