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 "Partner" column. If the entry in the IBAN line is empty, then "NO" should be entered.

Any Idea?

Lists
microsoft lists
SharePoint Online

5 Replies

  • Rob_Elliott's avatar
    Rob_Elliott
    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'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)

Resources