I have a sheet (here) that I'm using as a base for appsheet.
I'm using this as a template so that when I get a new lot of jobs for a new project I can copy the template, dump the info and create a new app (copied from my app template)
The way it works is I copy/paste all the info from another sheet into TASK DUMP!, then arrayformula certain columns in specific order to TASKS! with formulas, checkboxes and data validations that I use as the reference in my app. I also need to be able to add extra rows to the DUMP sheet later on and have them show up on TASKS!
I'm having trouble with 2 things in the app..
1. I have a graph referencing the COMPLETED column, but it shows ALL of the rows, not just the ones with data.
2. I have a view that also shows all the empty rows.
I can't figure out how to dynamically remove all the empty rows from TASKS! and still be able to add extra rows in TASK DUMP! and have them show up in TASKS!
I assume another way would be to somehow create a slice to only show NOTBLANK rows in both the view and the graph in my app, but I also can't figure this out.
I've tried FILTER on my sheet, but this doesn't let me add new rows in TASK DUMP! and have them show up in TASKS! with still no empty rows below.
Pretty convoluted I know, but hopefully someone can understand what I'm trying to achieve and help me out.
Thanks in advance
Trot
LinkedIn
Twitter
