Forum Discussion
kr6el
Nov 19, 2021Copper Contributor
column on left & #### signs auto populating
Two questions. Sorry I don't know the terminology so I will try to make my baby talk understandable as possible. This is a mileage log I found on the net a few years ago. It is set up to be numbe...
kr6el
Nov 21, 2021Copper Contributor
Thanks for looking at this. Here is a copy.
BTW it is set up like a monthly entry. After about 31 entries that is all it will accept.
Riny_van_Eekelen
Nov 22, 2021Platinum Contributor
kr6el Well, somebody butchered the original template that had a structured table capturing all the data. The file you uploaded had all of the intelligence removed. I reinstated a structured table, with structured references and removed all the merged cells in the header rows. See if it works for you.
- kr6elNov 22, 2021Copper ContributorWow that's awesome! Thanks.
So will I be able to enter several months of logs now?- Riny_van_EekelenNov 22, 2021Platinum Contributor
kr6el Just type a date below the last row in the table and the table (including formulae) will extend. If not, let me know.
- kr6elNov 22, 2021Copper Contributorthe table is extending. Thanks.
The odometer is totaling backwards. For example - starting 100 miles, finish 200 miles = -100 miles