Forum Discussion

Pn1995's avatar
Pn1995
Brass Contributor
May 31, 2022

Automatically fill a Sharepoint list field

Hi  We have a field in a Sharepoint list that has Yes / No answers   We want another field to automatically be completed if the answer to the Yes/No field is set to No   Anyone know if thsi can ...
SharePoint Online
khushbu's avatar
khushbu
Copper Contributor
May 31, 2022

Hello,Pn1995 

 

I hope this is helpful solution,

Add Yes/No filed and select type of calculated filed then add formula 

=IF([Yes/No],"Complete","IN Progress")

 

 

  • Pn1995's avatar
    Pn1995
    Brass Contributor
    May 31, 2022

    khushbu

     

    Thanks

    I added the below: (Harm Yes or No is my other column)

    =IF([Harm Yes or No],"No","Very Low")



    However I get this error:

     


    I'm I missing a step?

     

    Thanks

     

     

    • ganeshsanap's avatar
      ganeshsanap
      MVP
      May 31, 2022

      Pn1995 You need to create a "Calculated column" instead of "Single line of text" column.

       

      Also, what is the data type of "Harm Yes or No" column?
      If data type of "Harm Yes or No" is "Choice" or "Single line of text" use this formula: 

       

      =IF([Harm Yes or No] = "No", "No", "Very Low")

       

       If data type of "Harm Yes or No" is "Yes/No" use this formula: 

       

      =IF([Harm Yes or No], "Very Low", "No")

       

      First value in above IF function is for Yes/true value.

      Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    • khushbu's avatar
      khushbu
      Copper Contributor
      May 31, 2022
      Can you tell me about Harm Yes or No is Which type of column?
      • Pn1995's avatar
        Pn1995
        Brass Contributor
        May 31, 2022
        Its just a single line of text field

Resources