Thank you for the video, but shouldn't these tasks be added to your daily task manager instead of reminding yourself to look at a different page each morning?
Can you share the Due Date formula as you mentioned in the video? I cannot get mine to work. I am using: dateAdd(prop("Last Completed"), if(prop(prop("Frequency") == "Daily", 1, if(prop(prop("Frequency") == "Weekly", 7, if(prop(prop("Frequency") == "Monthly", 30, if(prop(prop("Frequency") == "Quarterly", 90, if(prop(prop("Frequency") == "Yearly", 365, 0))))), "days")))))) and getting a "Too few arguments in function dateADD" error
For my use I added Bi-Weekly, Bi- Monthly and 6 Monthly Options. I am using this to build a cycle maintenance management system so I know when I who I need to check or service on my various bikes (I have a few) I have put my formula below, hope this helps you! NOTE in my formula "Last Complete" is changed to "Last Done" dateAdd(prop("Last Done"), if(prop("Frequency") == "Daily", 1, if(prop("Frequency") == "Weekly", 7, if(prop("Frequency") == "Bi-Weekly", 14, if(prop("Frequency") == "Monthly", 30, if(prop("Frequency") == "Bi-Monthly", 60, if(prop("Frequency") == "Quarterly", 90, if(prop("Frequency") == "6 Monthly", 182, if(prop("Frequency") == "Yearly", 365, 0)))))))), "days")
The formula didn't work for me. I asked Chat GPT for help and it got it right after a while: ''The main difference between the formula that worked and the original one you provided lies in the nesting of the prop() functions and the placement of the string literal "days". Let's break down the differences: Nesting of prop() functions: In the original formula you provided, there was nesting of prop() functions like this: prop(prop("Last completed")). In the corrected formula, we removed the nested prop() functions to simplify it: prop("Last completed"). Nested prop() functions are unnecessary and can cause syntax errors. Placement of the string literal "days": In the original formula, the string literal "days" was placed outside the if condition, causing a syntax error. In the corrected formula, the string literal "days" was placed inside the dateAdd() function, immediately after the conditional expression, like this: "days". Placing the string literal "days" inside the dateAdd() function ensures it is properly interpreted as the unit of time to add to the date. By making these adjustments, we were able to resolve the syntax errors and create a functional formula.''
Excellent video. Very easy to follow and very helpful. Thank you!
Great video! This helped so much thank you!!
Just what I need, thank you so much for your tutorial
No problem! Hope you enjoyed it.
Hey ! Great tutorial ! Do you think it’s possible to repeat the frequency when you click on a checked box ? I try but it’s really complicated 😅
This channel will be successful
I hope so!
Hoping you're going to add this template soon :)
Maybe in the future. Working on the next Notion video atm (Hope to be out this weekend)
Why dont you give this one for download?
Wonder how you use the status… as you have to remember to put it back to Not Started after you have done the task…
Just move it with the board. I would prefer to have a status than no status
Thank you for the video, but shouldn't these tasks be added to your daily task manager instead of reminding yourself to look at a different page each morning?
Thankyoou! There's not enough vids like this, just ads for templates.. I wanna build my own pages, not get a template.
Can you share the Due Date formula as you mentioned in the video? I cannot get mine to work. I am using: dateAdd(prop("Last Completed"), if(prop(prop("Frequency") == "Daily", 1, if(prop(prop("Frequency") == "Weekly", 7, if(prop(prop("Frequency") == "Monthly", 30, if(prop(prop("Frequency") == "Quarterly", 90, if(prop(prop("Frequency") == "Yearly", 365, 0))))), "days")))))) and getting a "Too few arguments in function dateADD" error
You have double prop in your equation. It should be:
dateAdd(prop("Last Completed"), if(prop("Frequency") == "Daily", 1, if(prop("Frequency") == "Weekly", 7, if(prop("Frequency") == "Monthly", 30, if(prop("Frequency") == "Quarterly", 90, if(prop("Frequency") == "Yearly", 365, 0))))), "days")
@@Lexee_boo You're awesome. Thank you!
@@Lexee_boo Thanks! This worked.
How can we make it alternate the people so everybody takes it in turns doing each chore?
I'm looking to add a "Bi Weekly" frequency, but I can't seem to add the code properly and I'm pulling my hair out trying to figure it out 😢
For my use I added Bi-Weekly, Bi- Monthly and 6 Monthly Options. I am using this to build a cycle maintenance management system so I know when I who I need to check or service on my various bikes (I have a few) I have put my formula below, hope this helps you!
NOTE in my formula "Last Complete" is changed to "Last Done"
dateAdd(prop("Last Done"), if(prop("Frequency") == "Daily", 1, if(prop("Frequency") == "Weekly", 7, if(prop("Frequency") == "Bi-Weekly", 14, if(prop("Frequency") == "Monthly", 30, if(prop("Frequency") == "Bi-Monthly", 60, if(prop("Frequency") == "Quarterly", 90, if(prop("Frequency") == "6 Monthly", 182, if(prop("Frequency") == "Yearly", 365, 0)))))))), "days")
Why when ever l but a cover doesn’t show from outside
this formula is not working for me
The formula didn't work for me.
I asked Chat GPT for help and it got it right after a while:
''The main difference between the formula that worked and the original one you provided lies in the nesting of the prop() functions and the placement of the string literal "days". Let's break down the differences:
Nesting of prop() functions:
In the original formula you provided, there was nesting of prop() functions like this: prop(prop("Last completed")).
In the corrected formula, we removed the nested prop() functions to simplify it: prop("Last completed").
Nested prop() functions are unnecessary and can cause syntax errors.
Placement of the string literal "days":
In the original formula, the string literal "days" was placed outside the if condition, causing a syntax error.
In the corrected formula, the string literal "days" was placed inside the dateAdd() function, immediately after the conditional expression, like this: "days".
Placing the string literal "days" inside the dateAdd() function ensures it is properly interpreted as the unit of time to add to the date.
By making these adjustments, we were able to resolve the syntax errors and create a functional formula.''
can you share the correct formula ?
@@MicheleSteeleTV dateAdd(prop("Last Completed"),
if(prop("Frequency") == "Daily", 1,
if(prop("Frequency") == "Weekly", 1,
if(prop("Frequency") == "Monthly", 1,
if(prop("Frequency") == "Quarterly", 3,
if(prop("Frequency") == "Yearly", 1, 0))))),
if(prop("Frequency") == "Daily", "days",
if(prop("Frequency") == "Weekly", "weeks",
if(prop("Frequency") == "Monthly", "months",
if(prop("Frequency") == "Quarterly", "months",
if(prop("Frequency") == "Yearly", "years", "days")))))) a bit different but works