I have a choice column "Program" which includes four options. If option A is chosen then I need Office Location (choice column) to populate. However, when I do conditional formatting, it is hiding Office Location column with any response from Program column. Conditional Formula on Office Location Column: =if([$Program] == 'A', 'true', 'false')
1 Answer
You don't need to use if statement here. It should be like =[$Program]=='A'
-
Removing if gives the error: enter a valid condition. =([$Program] == 'A', 'true', 'false')Rebecca– Rebecca2025-02-21 15:05:07 +00:00Commented Feb 21 at 15:05
-
Try exactly =[$Program]=='A' This expression is automatically evaluated as true or false; no need to explicitly state true/false in your expressionMatiur Rahman– Matiur Rahman2025-02-21 16:14:50 +00:00Commented Feb 21 at 16:14