Forum Discussion

EKIT415's avatar
EKIT415
Copper Contributor
Nov 11, 2021

Conditional formating for lookup column

Hi,  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 onl...
microsoft lists
SharePoint Online
Maggan Wåhlin's avatar
Maggan Wåhlin
Iron Contributor
Nov 11, 2021

EKIT415 

 

Try something like this:

 

{
  "$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','')"
  }
}

 

RL_Alexander's avatar
RL_Alexander
Copper Contributor
Jan 09, 2023

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

Resources