Edit conditional formula based on Lookup fields

%3CLINGO-SUB%20id%3D%22lingo-sub-2134916%22%20slang%3D%22en-US%22%3EEdit%20conditional%20formula%20based%20on%20Lookup%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2134916%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20%22Edit%20conditional%20formula%22%20for%20SharePoint%20list%20doesn't%20seem%20to%20work%20for%20me%20for%20lookup%20fields.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%203%20date%20fields%20in%20SharePoint%20list%20say%3A%3C%2FP%3E%3CUL%3E%3CLI%3EDate%201%3C%2FLI%3E%3CLI%3EDate%202%3C%2FLI%3E%3CLI%3EDate%203%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20hide%2Fdisplay%20them%20based%20on%20a%20lookup%20field%20called%20%22Category%22%20that%20has%20three%20corresponding%20items%3A%20Date%201%2C%20Date%202%20and%20Date%203.%26nbsp%3B%20For%20each%20of%20the%20date%20fields%2C%20I%20have%20entered%20something%20like%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3Dif(%5B%24Category.LookupId%5D%20!%3D%201%2C%20'true'%2C%20'false')%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20doesn't%20seem%20to%20hide%20%22Date%201%22%20field%20if%20I%20don't%20select%20%22Date%201%22%20from%20the%20dropdown%20(which%20is%20a%20lookup%20field).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20experienced%20this%20issue%20or%20know%20how%20to%20fix%20it%3F%20Could%20it%20be%20a%20bug%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2134916%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

The "Edit conditional formula" for SharePoint list doesn't seem to work for me for lookup fields. 

 

I have 3 date fields in SharePoint list say:

  • Date 1
  • Date 2
  • Date 3

 

I want to hide/display them based on a lookup field called "Category" that has three corresponding items: Date 1, Date 2 and Date 3.  For each of the date fields, I have entered something like:

 

 

=if([$Category.LookupId] != 1, 'true', 'false')

 

 

This doesn't seem to hide "Date 1" field if I don't select "Date 1" from the dropdown (which is a lookup field).

 

Anyone experienced this issue or know how to fix it? Could it be a bug?

0 Replies