I have a formula below where by the Today Output is not working, any advise. if(empty(prop("Due Date")), "", if(and(prop("Due Date") < now(), prop("Due Date") now(), prop("Due Date") now(), prop("Due Date") dateAdd(now(), 7, "days"), prop("Due Date")
Try replacing this part of the formula: if(prop("Due Date") == prop("Due Date") , "Today", to this instead: if(formatDate(now(), "MMMM D, YYYY") == formatDate(prop("Due Date"), "MMMM D, YYYY"), "Today",
Sure, you can just add them by clicking the + New button on any of the database views. This should bring up a new page where you can add the goal and the deadline. After you've filled out the deadline, the goal will automatically show up in the appropriate quarter. :)
the formula formatDate("Deadline,¨Q¨) does not work it says Q is not defined. [14,15] Invalid character "¨". [118,119] Invalid character "¨". [120,121]
Hi, congratulations on your videos. I need to create a database for my studies. I need to enter the amount of pages I have to study for a subject and [a formula [(?) I don't know how to do it] that calculates how many pages a day I have to study in a period of time (from the beginning to the exam) to organize make the most of my time. can you help me? Or does anyone who follows you know how to do it? I welcome suggestions and better ideas. Thank you❤
You could start by adding two number properties. One for the amount of pages you need to study and another for the days left until your exam. You'd then add a formula property that just does the amount of pages divided by the days left. If you also want the days left until the exam to be automatically calculated for you then you can use the dateBetween() function. You'll need a date property with the exam date but then you can input this formula: dateBetween(prop("Date"), now(), "days")
This tutorial was so easy to understand. Thank you!
You're very welcome! :)
Love your tutorials! They are so easy to follow. 🙂
Glad you like them!
Learning a lot from you, thanks!
Love your videos, I'm understanding how to use formulas.
I have a formula below where by the Today Output is not working, any advise.
if(empty(prop("Due Date")), "",
if(and(prop("Due Date") < now(), prop("Due Date") now(), prop("Due Date") now(), prop("Due Date") dateAdd(now(), 7, "days"), prop("Due Date")
Try replacing this part of the formula:
if(prop("Due Date") == prop("Due Date") , "Today",
to this instead:
if(formatDate(now(), "MMMM D, YYYY") == formatDate(prop("Due Date"), "MMMM D, YYYY"), "Today",
@@creative_cove Thank you so much, its working.
This was amazing. Thank you!!!
You're so welcome!
I love watching your videos!!
Thank you so much!!
i came looking for exactly this and i found it. amazing
i think you should slow down a bit, you go through too quickly but still great video
what’s the difference between a goal tracker and vision board?
They are pretty similar but I'd say that a vision board is more visual.
Great video. Can you please let me know how to add more goals after all this steps?
Sure, you can just add them by clicking the + New button on any of the database views. This should bring up a new page where you can add the goal and the deadline. After you've filled out the deadline, the goal will automatically show up in the appropriate quarter. :)
@@creative_cove thanks for the reply. Wish you a happy year 🎊
the formula formatDate("Deadline,¨Q¨) does not work it says Q is not defined. [14,15] Invalid character "¨". [118,119] Invalid character "¨". [120,121]
Hi, congratulations on your videos. I need to create a database for my studies. I need to enter the amount of pages I have to study for a subject and [a formula [(?) I don't know how to do it] that calculates how many pages a day I have to study in a period of time (from the beginning to the exam) to organize make the most of my time. can you help me? Or does anyone who follows you know how to do it? I welcome suggestions and better ideas. Thank you❤
You could start by adding two number properties. One for the amount of pages you need to study and another for the days left until your exam. You'd then add a formula property that just does the amount of pages divided by the days left.
If you also want the days left until the exam to be automatically calculated for you then you can use the dateBetween() function. You'll need a date property with the exam date but then you can input this formula:
dateBetween(prop("Date"), now(), "days")