Some Cells Refuse References and Won't Populate Referenced Data

Okay, after a few years using Numbers this is a new one on me!


Two tabs, each with a table.


One is the master and the second tab and table is the replication where I use = and then go to the master tab and table click on a cell I want to replicate in the copy tab / table.


Everything was fine until I got to J4 where a blue 0 appeared... I tried dragging the I4 cell data over to see if it would populate the "37d 23h" into it but still a blue 0? So I deleted the contents of the cell with its blue 0 and tried again. Blue 0... Deleted the column, nope.... Nothing but blue 0's?


The blue table is the master tab / table and the green tab / table is what I am using to mirror the contents of the blue table into the green table. Plea ignore the black font or blue font cell highlighting rules.


Thanks in advance for any help.






[Edited by Moderator]

MacBook Pro 16″, macOS 14.7

Posted on Aug 8, 2025 3:38 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 8, 2025 6:00 AM

In you screenshot you've hidden J in the source table. What's in that column? If it's blank that might explain a 0 there.


Also, I see you the format set to Number with decimals set to 0. That would mean percentages from your source table would be formatted as 0 if they are less than 50%. What happens when you change the Data Format to Percentage?


SG

5 replies
Question marked as Top-ranking reply

Aug 8, 2025 6:00 AM in response to Bardonicloud

In you screenshot you've hidden J in the source table. What's in that column? If it's blank that might explain a 0 there.


Also, I see you the format set to Number with decimals set to 0. That would mean percentages from your source table would be formatted as 0 if they are less than 50%. What happens when you change the Data Format to Percentage?


SG

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Some Cells Refuse References and Won't Populate Referenced Data

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.