I have a table of locations that are associated with many possible employee records in another table. I want to format the location name based on whether any employee associated with that location meets certain requirements (employee columns have a particular value)โฆ How can I do this since the associated employees are a ref list?
Solved! Go to Solution.
You canโt dereference a list like that, it doesnโt make sense. Remove the period and youโll get a list of all values for [column in other sheet] for all โback-referencedโ records. Maybe wrap it in ANY() if you just want to look at one random value from that list. Or use IN() , depending on what exactly your criteria is.
Youโve given us no information, so i have nothing to offer but this.
My apologies, it seemed enough information. To be more specific, I donโt understand how to code the formula for the format rule to โlookโ at the columns in another table since the only column in the table that establishes a relationship to the other one is a โback referenceโ list. This may not be possible, but I thought Iโd hazard to ask. I didnโt figure youโd want a miles-long explanation of the structure of my tables and columns.
I attempted: [back reference column name (which is a list)].[column in other sheet]=X
But it could not find the โcolumn in other sheetโ. Is there another way to accomplish this?
You canโt dereference a list like that, it doesnโt make sense. Remove the period and youโll get a list of all values for [column in other sheet] for all โback-referencedโ records. Maybe wrap it in ANY() if you just want to look at one random value from that list. Or use IN() , depending on what exactly your criteria is.
Thanks, I will give it a try. I am an old-school programmer and database guy, but that was 20+ years ago and havenโt used these skills in a long, long time. My lack of spreadsheet acumen doesnโt help. I come from a land of line numbers and procedural code.
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |