I’m seeing three different approaches to handling traversal of time in Tiller sheets. Two of them make sense to me, but the third, I’m not so sure about.
- Vertical date list - i.e. Transactions sheet - this makes sense because you can enter any date, and the data can be in any sort order and still makes sense, and still does the job well of feeding other sheets as a data source, so it’s completely flexible while still useful and useable
- Drop-down selection - i.e. Monthly Budget sheet - this make sense because it is a report, it is pulling from the Transactions sheet and can be any date from within the source data range, so it’s completely flexible while still useful and useable
- Horizontal date list with start date - i.e. Categories sheet - this I’m not sure about…
The reason (3) is confusing is that the start date is the first date for which I need to budget. Once I get 12, 18 or 24 months down the line I’m going to start running out of columns. Is the idea that I would just keep adding columns? Or is the idea that I should every 6 months update the start date to be 6 months later, and just keep re-using the same 24 columns? I haven’t found the policy stated anywhere.
I could of course just figure out any way that suits me but the fact that it is not explained in the Foundation sheet YouTubes and documentation leaves it up to me, which is in contrast to the other approaches, which seem more “joined up” in the thinking and explanation. If I add columns, I will be forever scrolling to the right – further and further as the years go by, which isn’t very useable. Whereas if I overwrite past budget data, I’ll be erasing history, which seems to detract from the usefulness.
Maybe Tiller has a suggested approach to this and I just haven’t found it yet?
The other issue with this remaining ambiguous is that it seeps its way into the community. For example, the Category Schedule solution has a vertical timeline, with only 12 months. It’s unclear again, if I use that tool, what approach makes both useable and useful sense.