Finally I found the perfect tracker with an amazing tutorial! I'd like to ask you if it's somehow possibile to make the weeks automatically start from the first monday of the month? Thank you!
Hi there! No unfortunately it is not possible because this means that we need conditional formatting on gridlines, and this does not exist in Excel or Google Sheets. Thanks!
Great tutorial What happen when you change the month? Is there a way to have the data of how much you completed saved? Do you have to eliminate all the cheked boxes?
Hi there! When you change the month, the dates change at the top of the checkboxes. At the end of each month you should duplicate the tab to track another month. Thanks
Hi there! The SPARKLINE formula could be difficult to use at first because you have to use different symbol and each of them should be in the right order. Make sure to use the following symbols "{", "}", "(", ")", "," and ";" at the right place. Thanks
Finally I found the perfect tracker with an amazing tutorial! I'd like to ask you if it's somehow possibile to make the weeks automatically start from the first monday of the month? Thank you!
Hi there! No unfortunately it is not possible because this means that we need conditional formatting on gridlines, and this does not exist in Excel or Google Sheets. Thanks!
This is such a great tutorial! Keep it up
Thank you! We will try to create new video like this one in the future
Great tutorial
What happen when you change the month?
Is there a way to have the data of how much you completed saved?
Do you have to eliminate all the cheked boxes?
Hi there! When you change the month, the dates change at the top of the checkboxes. At the end of each month you should duplicate the tab to track another month. Thanks
i have trouble in 12:07 formulas, can u rewrite if i use ; not , ? thanks
Hi there! The SPARKLINE formula could be difficult to use at first because you have to use different symbol and each of them should be in the right order. Make sure to use the following symbols "{", "}", "(", ")", "," and ";" at the right place. Thanks
Explanation is great, but the whole video is too fast. Its impossible to follow along.
Hi there! You still have the option to pause the video or change the speed of it. Thanks
i got a problem in connecting the date part with month slicer
You could simply use the DATE formula and in the Month parameter it is a VLOOKUP formula to associate the text to a number (1 to 12)