Calculated Drop Down field with values from another List based on a condition

%3CLINGO-SUB%20id%3D%22lingo-sub-3015772%22%20slang%3D%22en-US%22%3ECalculated%20Drop%20Down%20field%20with%20values%20from%20another%20List%20based%20on%20a%20condition%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3015772%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20question%20regarding%20calculated%20fields.%20I%20have%20a%20created%20a%20calculated%20field%20that%20populates%20drop%20down%20options%20based%20on%20items%20from%20another%20sharepoint%20list%20if%20they%20meet%20certain%20conditions.%20The%20use%20case%20is%20the%20following%3A%3C%2FP%3E%3CP%3E-%20List%201%3A%20It's%20a%20list%20with%20candidates%20for%20potential%20hiring%2C%20it%20has%20multiple%20columns%20with%20differente%20data%20and%20one%20specific%20calculated%20column%20that%20populates%20a%20drop%20down%20with%20the%20positions%20that%20are%20currently%20%22Open%22%20for%20hiring%20in%20List%202.%3C%2FP%3E%3CP%3E-%20List%202%3A%20Contains%20all%20positions%20that%20have%20been%20opened%20for%20hiring%2C%20some%20are%20%22Open%22%20and%20some%20others%20are%20%22Closed%22%20becuase%20the%20positions%20have%20already%20been%20covered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20if%20a%20candidate%20from%20List%201%20had%20an%20Open%20position%20selected%20from%20the%20drop%20down%20but%20later%20on%20the%20position%20was%20Closed%20in%20List%202%2C%20the%20candidate%20form%20in%20List%201%20gets%20bugged%20and%20cannot%20be%20opened.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I%20have%20explained%20this%20well%20enough.%20I%20would%20really%20appreciatte%20some%20help%20here%20on%20how%20to%20work%20around%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3015772%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Hi All!

 

I have a question regarding calculated fields. I have a created a calculated field that populates drop down options based on items from another sharepoint list if they meet certain conditions. The use case is the following:

- List 1: It's a list with candidates for potential hiring, it has multiple columns with differente data and one specific calculated column that populates a drop down with the positions that are currently "Open" for hiring in List 2.

- List 2: Contains all positions that have been opened for hiring, some are "Open" and some others are "Closed" becuase the positions have already been covered.

 

The problem is that if a candidate from List 1 had an Open position selected from the drop down but later on the position was Closed in List 2, the candidate form in List 1 gets bugged and cannot be opened. 

 

I hope I have explained this well enough. I would really appreciatte some help here on how to work around this.

 

Thanks!

0 Replies