Forum Discussion
Solved
Conditional formula to hide/show columns in Sharepoint List Edit Form
Hi, I was able to create a formula based on this posting from Microsoft (link below) and it works great. However, I want to be able to write it so it looks at 2 different values in a field to show ...
- Hi,
Try this, it should work like a charm
=if([$Category] == 'Product' || [$Category] == 'Service','true','false')
Hey is there a way to do this but for if you want both conditions to be true for it to show instead of just one, E.g. for when you are referencing 2 different columns and one is a number as seen below.
=if([$Category]=='Product',=if([$Inventory]>='2','true', 'false'), 'false')
If Category is ‘Product’ and Inventory is 2 or less
=if([$Category]=='Product',=if([$Inventory]>='2','true', 'false'), 'false')
If Category is ‘Product’ and Inventory is 2 or less
