Brand new here and also brand new to spreadsheetsโbut I do have google drive access to create their docs and sheets. Iโm not certain if this is the appropriate place to post my question or notโbut it looks like this thread is similar to what I need to do. My issue: Iโm attempting to make time management, project coordination, between volunteers but the difficult part is those volunteers are using two different time reckoning systems that I have to figure out how to keep them coordinated with one another. This gets complicated to someone unfamiliar with the second time keeping system, but it is not complicated at all; it just runs on different rules than the one everyone else is used to using in terms of time/calendar. This would also require me (Iโm assuming??) to publish a new version each start of the new second systemโs months as they donโt begin with anything which can be cued from the normal time/calendar system people are using here.
Guessing I need to be able to set some values some how for each new month on the second system and coordinate it with the normal calendar system so that the app would coordinate once DAY 1 of the second time keeping system was established when that month began, coordinating with the normal calendar, say with the month beginning for example on, July 3, 2019; Then the second calendar system would follow its normal rules so that due dates and project timing can be coordinated by either time keeping system.
Any ideas about how to best go about doing that? If so, it would be greatly appreciated. I"m seeing this Birthday notification would be GREAT to push notifications out about other dates of interest including birthdays, anniversaries, holidays, etc. and may even solve the issue of letting both calendar keeping teams know each otherโs calendar at a glance, but Iโm not certain?
Example:
July 3: Day 1
July 4: Day 2
July 5: Day 3โฆ
July 31: Day 28โฆ
etc
LinkedIn
Twitter
