Forum Discussion

AkerblomSP's avatar
AkerblomSP
Copper Contributor
Mar 28, 2024

Hi! I'm using SP in Swedish at work and want to add conditional formatting for show/hide columns on

Hi!

I'm using SP in Swedish at work and want to add conditional formatting for show/hide columns on a listform.

 

I want pretty much exactly this but translated into swedish syntax:
=if([$Category] == 'Product Management', 'true', 'false')

 

I've tried to iterate variations without any luck...
=OM([$Category] == "Product Management"; "sant"; "falskt")

 

Anyone with clue?

  • AkerblomSP 

     

    I think you don't need to use Swedish for conditional formulas. You can use English for formulas like: 

     

    =if([$Category] == 'Product Management', 'true', 'false')

     

    Just make sure you are using correct internal name of column and value to compare with single quote ('Product Management') in the formula. 

     

    Where [$Category] is an internal name of your Request column in SharePoint list in this format: [$InternalNameOfColumn]. You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?


    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.

  • AkerblomSP 

     

    I think you don't need to use Swedish for conditional formulas. You can use English for formulas like: 

     

    =if([$Category] == 'Product Management', 'true', 'false')

     

    Just make sure you are using correct internal name of column and value to compare with single quote ('Product Management') in the formula. 

     

    Where [$Category] is an internal name of your Request column in SharePoint list in this format: [$InternalNameOfColumn]. You can get the internal name of your SharePoint list columns by following this article: How to find the Internal name of columns in SharePoint Online?


    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.

    • AkerblomSP's avatar
      AkerblomSP
      Copper Contributor
      Thank you! My column name was wrong as you pinpoint and I removed the IF-statement in the formula: [$Category] == 'Product Management'.

      All set 🙂
      • ganeshsanap's avatar
        ganeshsanap
        MVP

        AkerblomSP 

         

        You are welcome. I am glad it worked for you.


        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.

Resources