Free Schedulling Sheet

I've developed the most efficient tool to manage weekly events. Come check out.

Why?

I will try to be succinct because this story is long and boring. 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 song from the 60s. And every Tuesday, I would post a song from the 70s 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 do not provide a good way to manage tasks or see the big picture.

With this spreadsheet, you can post everything at once, set the repetition interval, and allow others to add data without compromising data visualization. You can plan and structure lists, and have control over every task for the entire year.

Also, the biggest challenge was to put this inside a formula, instead of using .gs scripts or VBA. With Google Sheets, you have the power.

How does it work?

First, you need to put all the information in the 'DATA' sheet. The front sheet is for visualizing the distribution of the data.

If you want to add more data or categories, create a new column in the 'DATA' sheet and name the category in the first line. To make a new column in the FRONT sheet, select the column, press Ctrl + C, and copy it to a blank column. Or drag to the left, like you do with normal functions *Recommended

 

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

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

Line 3 | Week Day : This shows the day of the week.

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 : Starts on: 01/01/22, with an interval of 1. So, every single line is 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 do I copy this?

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

How does it work? (Technically)

The code below is responsible for all the magic. (Added in line 6 [hidden] for security )

=if(B5<>"";iferror(TRANSPOSE(ARRAYFORMULA(TRIM(SPLIT((rept("; ";(B1-DATE(YEAR(TODAY());1;0))))&";"&CONCATENATE(INDEX(query(,!$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