Conditional formating for lookup column

Occasional Contributor


I am trying to add conditionally format a column to only appear in the form unless "other" is selected from a lookup column 

I have tried using - i thikn 99 is the ID for other but i could only find this out by creating a test list and looking up Other and ading ID column attached to this. 

=if([$Project.LookupID] != 99, 'true', 'false')

=if([$Project] != 99, 'true', 'false')

=if([$Project] == Other, 'true', 'false')


i have also tried 

=if(Number(substring([$Project],0,indexOf([$Project],';#'))) == 99, 'true', 'false')

=if(substring([$Project],indexOf([$Project],';#')+2,1000) == 'Other', 'true', 'false')

which are from the windows 'learn to use conditional formulas in a list form" site

None of these formulas work. 


1 Reply



Try something like this:


  "$schema": "",
  "debugMode": true,
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "display": "=if([$ColumnD]=='Yes','none','')"