I'm finding that reports are not refreshing accurately when the underlaying data, in a smartsheet, has changed (and been saved before you ask). The source data is around 20 rows so this should not be a problem.
We have seen this issue previously. It seems to fix itself - i.e. we make no changes