I am creating a custom report based of the report template in the Vehicle screen. For whatever reason, whenever I create a column to report a date, that column will hide itself when I generate the report in Geotab. Specifically, the date data is converted to text using the formula =TEXT(Data!$B$2,"MM/DD/YYYY"). This column will always report the same date in every row since it is pulling it from the Data tab cell where the RunDate is stored.
I have saved the template with all columns visible, yet it will come out of Geotab hidden. If I move the formula to another column, then that column becomes hidden. If I repeat the formula in 3 columns, all 3 will become hidden. Is there some sort of setting built into the Vehicle template that is hiding columns if certain data is displayed (or is it if all the data is the same for the whole column?) and if so, how do I disable this? The report needs to be in a specific format and the repetitive data is part of this format.