Forum Discussion

cAhler's avatar
cAhler
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 "...
Lists
microsoft lists
SharePoint Online
cAhler's avatar
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's avatar
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's avatar
    cAhler
    Copper Contributor
    Sep 12, 2023

    Rob_Elliott hmm... What's going wrong?

     

    • cAhler's avatar
      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.

Resources