Reports not listing entries when it should

gillesb ✭✭
edited 12/09/19 in Smartsheet Basics

Hi there,

We manage store fitouts. With every project, the sheets are identical. I have created 16 sheets to manage 16 projects.

I have just recently added few rows, all identical, on all 16 sheets.

When I run reports, it does list certain rows (newly created).

Puzzled, I simplified the report to the bare minimum: I now search rows which "contains" a simple word in the primary column. Couldn't be simpler.

It displays the rows from 8 sheets only, when there should be 16 rows displayed (as there are no difference whatsoever between the 16 sheets).

Note: It only happens with the newly created rows. If I query to display a word from an original row (not a recently added row), it displays all 16 rows.

What could have gone wrong? It is also so random:  Why 8 rows, not all 16 rows?

Can someone help?