Sample Data
This table lists drawings and their external reference paths with attachment status.
| Cell | Value |
|---|---|
| A1 | Drawing1.dwg |
| A2 | Drawing2.dwg |
| B1 | XREF_Path |
| B2 | C:\Projects\Drawings\ |
| C1 | Status |
| C2 | Not Attached |
This table lists drawings and their external reference paths with attachment status.
| Cell | Value |
|---|---|
| A1 | Drawing1.dwg |
| A2 | Drawing2.dwg |
| B1 | XREF_Path |
| B2 | C:\Projects\Drawings\ |
| C1 | Status |
| C2 | Not Attached |
IF(C2="Not Attached", CONCATENATE(B2, A2), "Attached")A B C 1 Drawing1.dwg XREF_Path Status 2 Drawing2.dwg C:\Projects\Drawings\ Not Attached References: A2, B2, C2 used in formula
A B C D 1 Drawing1.dwg XREF_Path Status XREF_Full_Path 2 Drawing2.dwg C:\Projects\Drawings\ Not Attached C:\Projects\Drawings\Drawing2.dwg
XREF.INSERT adds blocks, EXPORT saves files, COPY duplicates objects.Pass the test and this pattern moves unknown