Linked data

[Task Lead Nicole]

Is there a way to create a macro or formula or a cell format to populate a
cell that is getting info (external data) from a link to a cell in another
worksheet so that it just inserts an "X" or something like that IF the source
cell is NOT NULL (or not empty)?

 

[JE McGimpsey]

One way:

=IF(Sheet1!A1<>"","X","")