I have two Docs:
In “Students” I have a table called “Student Master” that contains one row for each student, along with all their demographic data, etc.
In “Meetings”, I have created a “copy” of “Student Master” using Cross Doc. I also have a second table called “Meetings Master”. Each row of Meetings Master contains information about a meeting where a student was discussed. A field in this table is “Student Number” which is used to identify the student who was discussed in the meeting. There are also several formula fields in the Meetings Master table that use the Student Number to reference related fields from the Student Master Cross Doc table, such as “Team”, “Gender”, etc.
There are a few questions I’d like to resolve:
- In the Student Master Cross Doc table, a given student’s team may be ‘7 Blue’. When it is displayed in the Meetings Master table, it shows up as ‘[7 Blue]’. Why does it add brackets when it is displayed as the result of a formula in the Meetings Master table?
- When I apply a Conditional Formatting rule to the Student Master table (the one that was the result of the Cross Doc retrieval), it displays properly in the Student Master table, but the formatting doesn’t get inherited by the Meetings Master table (example: ‘7 Blue’ is colored blue in the Student Master table but ‘[7 Blue]’ in the Meetings Master table is not. Why not?
Note - none of the conditional formatting is being applied to the Cross Doc source table - that is straight text. I’m just trying to get it to look “nice” in the user-facing Meetings Master doc.