Conditional formating for lookup column

Question

Hi,&nbsp;I am trying to add conditionally format a column to only appear in the form unless "other" is selected from a lookup column&nbsp;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.&nbsp;=if([$Project.LookupID] != 99, 'true', 'false')=if([$Project] != 99, 'true', 'false')=if([$Project] == Other, 'true', 'false')&nbsp;i have also tried&nbsp;=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" siteNone of these formulas work.&nbsp;&nbsp;

maggan wåhlin · Answer

EKIT415&nbsp;&nbsp;Try something like this:&nbsp;{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "debugMode": true,
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "display": "=if([$ColumnD]=='Yes','none','')"
  }
}&nbsp;

rl_alexander · Answer

Question:I have a list that allows users to enroll in classes from based on a separate course list.&nbsp; The Lookup Field is [StartDate].&nbsp; &nbsp;How do I only show the Course Dates greater than Today()?I tried the following with no success:=if([StartDate.lookupValue]&lt;Today(), 'hidden', 'visible')

Forum Discussion

Conditional formating for lookup column

Share

Resources