Hi all.
I am looking to make a new column value based on the data in other columns in a row.
For Example,
Project 1 | Project 2 | Project 3 | Project 4 | Overlap | |
Asset A | X | X | YES | ||
Asset B | X | X | YES | ||
Asset C | X | X | YES | ||
Asset D | X | X | YES | ||
Asset E | X | NO |
Overlap would be the new column if 2 or more Projects have an X if only one project has an X it would say no.
Thank you and I look forward to the solutions.
Hi @NY2BOS
Here's how I would do this. This solution is dynamic in case more projects come into the dataset: