Sorry if this has been covered, but I couldn’t easily find an answer.
In the example Table, I have three types of lookups that I’m pulling in - Project, Task, Product. They each have their own lookups from another table called Status. So “Project” can have the status “In Progress” just like “Task” in its own table.
So can I set up this “Status” column in this table to read each of the lookups and pull its status? I suppose I’d get a conflict if more than one of the first three columns is filled and there were conflicting Status? Is it possible to determine a priority, so say whatever the status in the first column is would be the one showing, no matter of the other columns have values?
Hope that’s clear and I appreciate the help!