Sharepoint conditional column formula not working

Copper Contributor

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 Program_x0020_Type

 

So if the 'Program Type' column choice does not equal 'Sustaining', I want the column 'Current Phase Gate' to be visible. 

 

Here are the formulas I tried with no luck 

=if([$Program_x0020_Type]<>’Sustaining’, ’true’, ‘false’)

=if([$Program Type]<>’Sustaining’, ’true’, ‘false’)

=if([$Program Type]<>’Sustaining’, ’true’, ‘false’)

 

The message I keep getting is 'Enter a valid condition' , can anyone see what is wrong with my formula?

Caterpillar_94_0-1676068610173.png

 

 

4 Replies

@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.