Free Schedulling Sheet

Why?

I will try to be succinct, because this story is long and boring. But long story short, I needed a tool to help me with the organization of a social network page.

Imagine this mechanism: Every monday I would post a music from the 60's. And every Tuesday, I will post a music from the 70's, and so on and so forth. This would take me forever to do in most of the tools I have tested. And also, those tools does not provide a big picture, of a good way of delimit tasks.

With this Spreadsheet, you can post all it once, set the interval of repetition, and allow other people to add data, without compromising the visualization of the data. you can plan and structure list, and have control of every single task in a year.

Also, the biggest challenge was to put this inside a formula, instead of putting with .gs scripts or VBA. In sheets, you have the power.

How does it work?

First thing you need to know, is that you will have to put all the information in the 'DATA' sheet. The front is to visualize the distribution of the data.

If you want to add more data, more "categories", I would need only to create a new column in the sheet 'DATA', put the name of the category in the first line. To make a new column in the FRONT sheet, you need just to select the column, press ctrl + c, and copy in a blank column. Or drag to the left, like you do with normal functions *Recommended

 

In the line 1, A | Starts in: You can choose when (day, month and year) the event will start.

In the line 2, A | Interval : You can set the interval. 

Line 3 | Week Day : Just informative : Shows the day of the week ( duh )

Line 4 | Today's Tasks : Shows the event of the day. And if you go down in the sheet, you will see that the today date is also marked in green.

As you can see in the picture. To the:

Column B, I set: Starts in: 01/01/22, interval 1. So, every single line was filled.

Column C, I set: Starts in: 02/01/22, interval 2. So after day 2, the other days will be filled with intervals of 2.

Column D, the same logic as before, interval 3, 03/01/22. Repeats the category every 3 days. Easy.

I allowed the editing of the intervals: B5:H5 and B1:H2 so you can test it. You will have full control of the sheet when you make a copy of it.

You can increase the interval, increase the categories, personalize everything. You can do whatever you want. Just copy this sheet for you and you are free to go.

Iframe | * Prefer open in a new tab below.

Open in a new tab

How can I copy this?

Click on the link or in the window (iframe), File > Make a copy

How does it work? (Technically)

The formula below is responsible for all the magic.

=if(B5<>"";iferror(TRANSPOSE(ARRAYFORMULA(TRIM(SPLIT((rept("; ";(B1-DATE(YEAR(TODAY());1;0))))&";"&CONCATENATE(INDEX(query(DATA!$2:$54;"select "&(SUBSTITUTE(ADDRESS(1;MATCH(B5;DATA!1:1;0);4);1;""))&" ")&(rept(" ;";B2))));";"))));"Loading...");"Select Data on cell 5")

I simply add the cell of the interval to a formula that adds the character ";" to work like a line-break. The rest of the commands, are for guaranteeing that I would be able to get the categories without obligating the user to know vLookUp to manage the data.

And the best of all. It's free, Creative Commons, 0,00, free of charge. Grab your copy. 

Bye