Created
November 20, 2019 21:55
-
-
Save Zax37/274df2a0920c5d37a3acc1209ac8802e to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Date: select first date | |
| StartOfDateWeek: fromTimestamp(timestamp(prop("Date")) - (((day(prop("Date")) == 0) ? 7 : ((day(prop("Date")) - 1) * 24 + toNumber(formatDate(prop("Date"), "H")))) * 60 + toNumber(formatDate(prop("Date"), "m"))) * 60 * 1000) | |
| WeeksFromOriginal: ceil(dateBetween(now(), prop("Date"), "days") / 7) | |
| NearestDate: dateAdd(prop("Date"), prop("WeeksFromOriginal"), "weeks") | |
| Whenever it's 24 hours from last event, NearestDate should update to same + 7 days. |
Well, to be honest, those are indeed biggees, so I've been doing that (repetition, workflows, etc.) in ClickUp with no trouble at all.
I actually found ClickUp to be pretty complex. But to each his own I guess.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Well, to be honest, those are indeed biggees, so I've been doing that (repetition, workflows, etc.) in ClickUp with no trouble at all.