I'm trying to create a filtered lookup from a 'Projects' list that sits on a SharePoint site.
I followed the steps to create a filtered column in a SharePoint list as outlined here: How to make a filtered lookup field
I added a new calculated column named 'Archived' to my lookup list to filter my values. The column type is 'choice' with choices of 'Yes' and 'No'. The calculated column is named 'Filtered Title' and I'm using the following formula:
However, instead of blank spaces in my 'Filtered Title' column where the value is 'Yes', I get error '#Value!'.
Would you be able to advise please where I'm going wrong?
Thanks in advance for your time!