Forum Discussion
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?
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.
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.
- Thank you! My column name was wrong as you pinpoint and I removed the IF-statement in the formula: [$Category] == 'Product Management'.
All set 🙂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.
