Hello
In the “Coor CA” primary view of my AppSheet App - It shows all blank rows as you can see below.
and that maybe because the “Coor CA” sheet in the main Googlesheet pulls data automatically from another sheet called “seller CA” - as you can see below:
►My question if you please:
1- How can I get red of above blanks? and is the reason I explained above can really cause the blanks to show?
2- How can I do the exact formula result directly in Appsheet? should I do any ref. Plz explain thoroughly.
Thanks indeed
No, The formula pulling data from the other sheet is not the problem. The blank rows likely have actual “blank” values in one of more of the columns. Confirm that the cells are empty - i.e. no blanks or other similar characters.
I don’t know what you mean by “exact formula result directly in AppSheet”.
2 Likes
@WillowMobileSys
Hi and thank you for your kind help, for first part there is no blank cell or row.
for the second part - I meant instead of writing the formula (any formula) inside google sheet how can I write it in app sheet instead.
The fact that the AppSheet view showings a grouping of "blank" means that AppSheet thinks they are blank values. To get ride of those rows, I would recommend cropping the sheets to the data to eliminate those rows.
You have not indicated why you are copy data from one sheet into another, but yes you can handle that in AppSheet. I recommend eliminating, the “Coor CA” sheet and use Slices.
A Slice is a way to divide up the original table or have a duplicate copy. The columns still are based on the original table definition but with Slices you can implement views tailored to the Slice data.
To get started with Slices I recommend starting with this article:
1 Like
Hi and thank you all indeed I’ve solved the problem. I also have stopped copying data from one sheet to another and found a proper way to handle that via slicing option. Thanks for your hints and help.
1 Like
