If a value from Column A is found in Column B, can the occurrence be shown as "true".
I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these values are actively changing. (Note: The list "Column A" is also extensive so manually entering each Active Project would be burdensome)
Column A= Active Projects - Store #
Column B= Store #
Column A is a list of projects that are currently active, while Column B is a list of all sites that have already been visited (entered through a form). My end goal is to have a chart or graph showing the active projects that have already been visited, and which ones have not.
Help Article Resources
Check out the Formula Handbook template!