Here is the scenario. I have an excel table with a Gantt chart. This Gantt chart is done via conditional formating. If I want to add this table into appsheet without the Gantt showing as column, it is simple in excel. I just need to define the column range for the table. There is an insert table function in excel. Appsheet will then only take this table and ignore the columns which come after which are just 1,2,3,4,5…30,31 representing days.
I prefer google sheet because I seem to get more hurdles with excel. Is it possible to define which columns to take into appsheet with google sheet?