Forum Discussion
Sharepoint conditional column formula not working
I have a column titled 'Current Phase Gate' I want the visibility of this column to be based on a prior drop-down selection from a column titled 'Program Type' with an internal column name as Pr...
Caterpillar_94 for not equals to you need to use != not <>.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott Hey Rob, much thanks for the reply. I tried using "!=" and still get the 'please enter a valid condition' reply
- It looks like your single quotes are wrong
Your syntax: =if([$Program Type]<>’Sustaining’, ’true’, ‘false’) which gives an error.
My syntax: =if([$ProgramType] != 'Sustaining', 'true', 'false') which works.Hi Rob, I think I found the issue and I should've mentioned this in the OP. The column I'm trying to perform this on is a Person field and I don't think SharePoint likes that.