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