Feb 10 2023 02:38 PM
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?
Feb 11 2023 02:33 AM
@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)
Feb 12 2023 07:34 PM
@RobElliott Hey Rob, much thanks for the reply. I tried using "!=" and still get the 'please enter a valid condition' reply
Feb 13 2023 12:47 AM
Feb 16 2023 11:30 AM - edited Feb 16 2023 11:30 AM
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.