Filter Lookup Column based on Status from Child List(Filtering lookup columns)

Recently, I came across a problem where I have to filter values in a Lookup column based on status(True/False) from a child list. At first i thought I will do it via Sharepoint Designer but later I found out that it is not as easy to customize it in SharePoint 2013 so I came up with a solution which is quite easy and you donot have to write any code for it.

The following are the steps to create a filtered lookup column;

1. Create two Lists. A Parent List and a Child List.
2. Create a column in the Child List with name 'Status' as shown in the following figure.
   
   
   
   
   
3. Create a calculated column in the Child List with the formula shown in the following figure. Here the formula is copying the Title column value to the calculated field if the status is 1.

4. Now go to your Child List and check whether the calculated field is working and filling  itself with the Title column when status is true as shown in the following figure.

5. The Last step is to go into your Parent List and create a column with lookup type and refer the Child List along with the calculated column.

6. That's it...Test your Parent List..Lookup should now only show the values with status 'True' or 'Active'.