I have been struggling for almost a month trying to complete a project that required multiple databases with multiple formulas calling specific filtered information. I was struggling to understand map() & filter() and the new dot notation, and was totally lost when it came to current. You are the first person that I've encountered who had any answers at all for how these work. You explained everything SO thoroughly and made it -simple- for me to start actually writing Notion formulas fluently. Seriously, after watching this video I have gotten more done in the last four hours than I have in a whole month. I see a light at the end of the corner. Thank you.
With how many views this video already has... It seems like the time it would take to chapter this view would be amazing! Love the content! Keep it up!!!
Thanks so much for sharing! I am just learning the new formula 2.0. I had already watched all of the "big" Notion players' utube videos but still couldn't figure out how to do this one formula and your video helped me solve it. Thanks!
keep doing these videos man, super informative. very very helpful in better understanding the formula basics. i would like this video 100 times over if i could
Your videos are amazing, thank you so much for them!! Though I understood the video, there is a different situation I kind need to make work, if it's even possible. I have three databases on my habit tracker setup: Entries, Habits, and Goals. Entries is related to Habits, which is also related to Goals. Goals and Entries are not related. When I make a new entry, the habit property is automatically filled, and I want the goal corresponding to that entry to show up, too. Since Goals and Entries are not related, I used the map function to show the tasks related to the habit (kinda like a rollup), and it worked, but it showed ALL the goals related to that habit. Then, I tried to use the filter and contain functions to get only the desired goals, and that's where I'm struggling. I don't want the formula to return a text, I want the goal, as the map function does, but filtered. Exemple: To build the habit of exercising more (let's call it "Hulk Out!"), I have three goals: go to the gym 2x a week on June, 3x a week on July, and 5x a week on August. The "Worked out" button on my main page creates an entry that is automatically related to the "Hulk Out!" habit. There's a view for each month on the Entries database, so on the June view I wanna see only goals with "June", but the map function returns all three goals related to "Hulk Out!", and filter+contains returns a text (it returned a checkbox at some point, too; really don't know how that happened). It's important to make it show up through a formula. I could set a new relation between Entries and Goals, and set the buttons to automatically fill the goal property, but then I'd have to edit all the buttons, for all the habits I'm tracking, in the beginning of each month, manually. And, since the idea is to share the template as well, the less editing needed, the better. My inicial idea was way more complicated than this, and this is complicated enough for me hahahaha I'd really aprecciate if you could help me out. I'm sorry if it's confusing (it probably is). Anyways, thanks for the videos!!
this is very helpful, thanks so much! One thing though - I was wondering how you could get your 'output' table to dynamically update when new rows are added to the 'Input' database?
@@matthewappleton74 It's a good idea, but I have table with thousands of records... Is there a better way to do it instead of adding them all manually? It would be so much easier if we could reference a database instead of items in a relation. Also, there would be no need for a template and a two-way relatioship.
@@NotionWorkflow It's a good idea, but I have table with thousands of records... Is there a better way to do it instead of adding them all manually? It would be so much easier if we could reference a database instead of items in a relation. Also, there would be no need for a template and a two-way relatioship.
You can bulk edit relations with a table database view by hovering to the top left corner of the view and clicking on the box that appears when you hover there. Depending on your load limit (10,25,50,100), if it's a linked database view, you can change the relations of many different database relations in just a few clicks this way.
This video is super helpful! I'm not sure if I'm doing something incorrectly but I was wondering how you would filter something to only include a specific year. So instead of filtering with the "now" function, somehow filtering it to only show dates within 2023 for example.
Thank you :) Great question! You could use the .year() dot notation to filter by current year. Show name of related task whose year is 2023 in the date property. For example: map(prop("Tasks").filter(current.prop("Date").year()==2023),current.prop("Name"))
thanks for sharing this useful information. I would like to know how to count the checkboxes on a row. For example, I have five checkboxes in a row and I ticked three. I want to know the percentage of the check. How do I do? Thank you so much
You're very welcome! If you combine the two videos I've created here ua-cam.com/video/wH8CLfHdJeg/v-deo.html and here ua-cam.com/video/P7EAmIAJCBU/v-deo.html You can find what you're looking for!
Hi! thanks for this! I still need a little help! I have a client database , program database and program sold database. I have a relation from client to program sold and to program database. The relation to program sold is self filling with the purchase of the client but the relation to the program table still empty (it was just to link the table to be able to get its properties). Now, what I want to do is take each program sold and get a list of those that are from the same type (program database property) and finally get the one with the highest rank (also program property). But the problem is that since the program related column is empty, it wont get anything from it! I use the program sold as starting point but how can I compare its property in the program table to get the good one? I tried a lot of formula with map() and let() and find() but it still using local data. Thanks again!
I think you're trying to do too much by trying to cross reference everything through a formula. Once you figure out how to find what you're looking for between two database relations, then I'd work up to trying to connect the three together. You can find how to find your "highest rank" through this video: ua-cam.com/video/H24ak0i0tAc/v-deo.html You can find how to "count" by type through this video: ua-cam.com/video/JB4DX8XiykU/v-deo.html Good luck!
@@NotionWorkflow Hi, thanks for reply! I just realize why it would not works. I just made some link between table but letting them empty. I though that I could access other table data even if the column is empty (like making a find() in the other table or so. I just found a way to relate everything without empty column so I can use data to access other table. Thanks again!
For filtering formulas of a single select (for me it's status), is it possible to filter using OR? I want to see Tasks that are either Ready or Today. Thanks for your help!
I am a school teacher wanting to convert my worksheets into Notion. Can I make a formula refer to a specific answer in another cell coming from a related table's data? In other words, I want to convert a simple fill in the blank worksheet into a table (questions) with relation column (answers in a separate answers table) and have a 3rd column (formula column) determine if the answer is correct and award points if correct as one might do in Excel e.g. IF(B2 = "photosynthesis", 5, 0)-- In this example B2 is the answers selected from the choices in the answers column which happens to be a relations column to Answers table
Got things up and running however, trying to see if there is a way to speed up the whole process of setting up assignments: I have it so that the student can select from a single select column of all the word bank choices. Yet, that is going to be time consuming- I have to set up the select options manually whereas I was wondering if there was a way to make it faster by just linking/pulling in all the select option from the existing Text colmn (Descriptions in your example) in the table from which the relation is being made. In other words, I would make a datatable with the Answers, and in the Questions datatable, set up the select choices by pulling in/pointing to the answers column. Hope that is clear: trying to not manually create my select option everytime I set up an assigment
I see what you're saying. I think what you could try to do is create a list of text for a word bank and then use the includes or match formula function to see if a property includes a specified value or matches what you're referencing. The thing with that is that for every answer, you'd need to manually specify the answer, and you'd need to create a new formula for every question since you need to "check" if someone got that question right or wrong. What you could do is create a conditional statement that says, if question # is equal to 1, then test if this formula is true or not. I'd try creating 10 questions and 10 answers and see if you could create that first. Once you create a responsive set of relational databases, you can scale it and just create a button to create these sets of databases in one click. You can find the syntax for match and includes here: www.notion.so/help/formula-syntax Hope this helps!
@@NotionWorkflow Thank you. I am starting to let go of my idea for using Notion to handle scores as it has this strange inability to sum columns in any meaningful way beyond the Micky Mouse calculate tab at the bottom. I had a grand idea of using it to build my entire curriculum including lesssons, resources, assessments and grade book etc but alas it’s just not capable without some time wasting acrobatics. As well, the Ai (which I think is Claude-2) is so many orders of magnitude less intelligent than OpenAi that it foils my vision of an cutting-edge AI powered Learning Management System
Is there a way to let the formula property edit a different existing property (media property) ? Also great video, makes everything more easier to understand!
Thanks! There isn't a way to manipulate another property through a formula, and I think what you're looking for would be some sort of automation through a third party program. You could use a Notion automation to change certain properties through a trigger, but currently, you can't interact Notion Automations with formulas. Notion Automations don't support interactions with the media property either.
Hi there! Could you help me with a formula to sum the cost of sub-subtasks? I was able to come up with this so far: prop("Sub-item").map(current.prop("Sub-item").map(current.prop("Cost"))) - it will show the cost of the sub-subtasks (grandchildren) separated by a comma, but I cannot figure out how to sum it instead. Thank you!
Great video :) I have a cell that contains a formula and is constantly changing its results. It provides data (more specifically, a date) based on certain conditions. I was wondering if it's possible to save its information (the values returned) in another cell so that when I apply a condition to this new cell, it returns only one of the dates kept. Your help would be greatly appreciated!
Just to provide some context, I'm working on a spaced repetition sheet, and I have a cell that displays my upcoming revision date. After completing this revision, the cell changes its date based on certain conditions from my previous review. However, I would like to retain all the dates of the revisions and later use this data to organize all the reviews I've done
I would use a Notion Automation and create a new database entry with said date when certain conditions are met. Formulas are not ideal for what you're trying to do.
Hey, thank you for the video. These formulas are a struggle, but you ade verything quite clear! I have a question.. I am trying to set on my "left days" for a task that if a task has status submitted (with a formula when I put as a status "submitted" it automatically checks a box on the "done" column) it is completed. I don't like to have completed task (I still want to see them on the list tho) with 240days overdue. Do you have any formula for that? if(status=="submitted"..then what? Thanks a lot
I'd use the ifs statement to make it easier on yourself. Ifs(status == "submitted", "", Status != "submitted", Days + "days overdue"). The key is just to create an output that is empty with two quotation marks, and then to precisely choose your output when it's not "submitted"
@@NotionWorkflow alright, I have tried inserting what you have said at the end of the formula I already had for the "days left" and I was able to get the word "complete" there. But how do I remove the "6 days overdue" that still shows? The formula i am using is this one: if(formatDate(prop("deadline"), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY"), "💥 DUE TODAY 💥".style("b","u", "orange"), if(dateBetween(prop("deadline"), now(), "days") > 0, format(dateBetween(prop("deadline"), now(), "days") + 1) + " Days Remaining", if(dateBetween(prop("deadline"), now(), "days") > -1, "❗❗ Due Tomorrow".style("b", "u", "yellow"), if(dateBetween(prop("deadline"), now(), "days") < 0, format(abs(dateBetween(prop("deadline"), now(), "days"))).style("b", "red") + " Days Overdue ⭕".style("b", "red"), "")))) + ifs(prop("status") == "submitted", "", prop("status") != "submitted", "complete") 🙏
@@ellie1808 I'd restructure this into an ifs formula and start with the first condition that I mentioned. You'll just need to restructure the formula to match the ifs formula structure since you already have all the conditions. You can check out my video on that here: ua-cam.com/video/zkB0pW_k20w/v-deo.html Good Luck!
Could you tell me how I can indicate the next project in the formula when the previous project's status is completed and the name of the next project appears in the formula?
Don't think you can do that, unless you create a dependency with blocking/blocked by property and reference that relation within a formula property and it's related status property. You'd need to use a combination of a map and filter formula function.
I have a task data base and a project database. When in table view for my task databasse, I have a relational column with the project listed for each task. However, I would like the status(from my project database) and priority column(from project database) to be viewable within my Task database. Is this possible?
You could use the map function and do something like map("Tasks", current.status) or map("Tasks", current.priority). If you watch the video fully, you should find everything you need to know!
Can you help me, How if i wanna show only date now, I tried to change < to ==: map(In.filter(current.Date == now()), current.Date) But the formula didn't show anything.
I am trying to write a formula that will let me take my number of remaining classes divided by the number of remaining weeks to September 20th, 2024 to tell me how many classes I must complete per 1 weeks time. Rounded to the nearest tenth. I would also like to have a function that can adjust the rate based on how fast or slow I complete classes. This is what I have: round((28 - length(filter(["status"], current == "Done"))) / dateBetween(now(), parseDate("2024-09-20"), "weeks"), 1) But I'm getting this error: Function round received unexpected argument. [115,116] Please help! Lol
keep doing these videos man, super informative. very very helpful in better understanding the formula basics. i would like this video 100 times over if i could
I have been struggling for almost a month trying to complete a project that required multiple databases with multiple formulas calling specific filtered information. I was struggling to understand map() & filter() and the new dot notation, and was totally lost when it came to current.
You are the first person that I've encountered who had any answers at all for how these work.
You explained everything SO thoroughly and made it -simple- for me to start actually writing Notion formulas fluently.
Seriously, after watching this video I have gotten more done in the last four hours than I have in a whole month. I see a light at the end of the corner.
Thank you.
Wow! Thank you for your comment!! I make videos for comments like this 🙏💯
With how many views this video already has... It seems like the time it would take to chapter this view would be amazing! Love the content! Keep it up!!!
Thank you!! 😄
Thanks so much for sharing! I am just learning the new formula 2.0. I had already watched all of the "big" Notion players' utube videos but still couldn't figure out how to do this one formula and your video helped me solve it. Thanks!
That's Awesome! Thank you 😁
keep doing these videos man, super informative. very very helpful in better understanding the formula basics. i would like this video 100 times over if i could
Thank u very much, ur videos are so helpful ❤❤
Thank you very much! 😁🙏
This is absolutely helpful!! Thank you so much for such a great video 🙏🏻❤️
Thank you!! 🙏💕
Thank you so much, I solved my blocker thanks to your explaination !
That's awesome! 😁🙏
Thanks, I really appreciate this video.
Awesome! 🙌
9:28 why didn’t you use the map function & then added the relation property when creating the filter to show the date in the future?
FYI, i will be adding all of my questions here so you can help me answer it please. Thank you
10:37 what is the difference between sorting & filtering function?
What is the + built-in used for usually? (I forgot the timestamp mb HAHA)
This is another way you can approach the flexible nature of dot notation in Formulas 2.0
@@fiyazhossain4960 Learn about the differences between filter and sort here: www.notion.so/help/formula-syntax
Great video. Thanks so much!!!!
You're very welcome 😁🙏
Your videos are amazing, thank you so much for them!!
Though I understood the video, there is a different situation I kind need to make work, if it's even possible.
I have three databases on my habit tracker setup: Entries, Habits, and Goals. Entries is related to Habits, which is also related to Goals. Goals and Entries are not related.
When I make a new entry, the habit property is automatically filled, and I want the goal corresponding to that entry to show up, too.
Since Goals and Entries are not related, I used the map function to show the tasks related to the habit (kinda like a rollup), and it worked, but it showed ALL the goals related to that habit. Then, I tried to use the filter and contain functions to get only the desired goals, and that's where I'm struggling. I don't want the formula to return a text, I want the goal, as the map function does, but filtered.
Exemple:
To build the habit of exercising more (let's call it "Hulk Out!"), I have three goals: go to the gym 2x a week on June, 3x a week on July, and 5x a week on August.
The "Worked out" button on my main page creates an entry that is automatically related to the "Hulk Out!" habit.
There's a view for each month on the Entries database, so on the June view I wanna see only goals with "June", but the map function returns all three goals related to "Hulk Out!", and filter+contains returns a text (it returned a checkbox at some point, too; really don't know how that happened).
It's important to make it show up through a formula. I could set a new relation between Entries and Goals, and set the buttons to automatically fill the goal property, but then I'd have to edit all the buttons, for all the habits I'm tracking, in the beginning of each month, manually. And, since the idea is to share the template as well, the less editing needed, the better.
My inicial idea was way more complicated than this, and this is complicated enough for me hahahaha I'd really aprecciate if you could help me out.
I'm sorry if it's confusing (it probably is). Anyways, thanks for the videos!!
I have a feeling that this video might help you find what you're looking for: ua-cam.com/video/9u_HLcZTkQU/v-deo.html
this is very helpful, thanks so much!
One thing though - I was wondering how you could get your 'output' table to dynamically update when new rows are added to the 'Input' database?
Actually - think I sorted it, if the input uses a template that already references 'Output', could that work?
Exactly. You can use a database template to pre-configure a specific relation to Output 👌
@@matthewappleton74 It's a good idea, but I have table with thousands of records... Is there a better way to do it instead of adding them all manually? It would be so much easier if we could reference a database instead of items in a relation. Also, there would be no need for a template and a two-way relatioship.
@@NotionWorkflow It's a good idea, but I have table with thousands of records... Is there a better way to do it instead of adding them all manually? It would be so much easier if we could reference a database instead of items in a relation. Also, there would be no need for a template and a two-way relatioship.
You can bulk edit relations with a table database view by hovering to the top left corner of the view and clicking on the box that appears when you hover there. Depending on your load limit (10,25,50,100), if it's a linked database view, you can change the relations of many different database relations in just a few clicks this way.
This video is super helpful! I'm not sure if I'm doing something incorrectly but I was wondering how you would filter something to only include a specific year. So instead of filtering with the "now" function, somehow filtering it to only show dates within 2023 for example.
Thank you :) Great question! You could use the .year() dot notation to filter by current year. Show name of related task whose year is 2023 in the date property.
For example:
map(prop("Tasks").filter(current.prop("Date").year()==2023),current.prop("Name"))
thanks for sharing this useful information. I would like to know how to count the checkboxes on a row. For example, I have five checkboxes in a row and I ticked three. I want to know the percentage of the check. How do I do? Thank you so much
You're very welcome! If you combine the two videos I've created here ua-cam.com/video/wH8CLfHdJeg/v-deo.html and here ua-cam.com/video/P7EAmIAJCBU/v-deo.html You can find what you're looking for!
Hi! thanks for this! I still need a little help! I have a client database , program database and program sold database. I have a relation from client to program sold and to program database. The relation to program sold is self filling with the purchase of the client but the relation to the program table still empty (it was just to link the table to be able to get its properties). Now, what I want to do is take each program sold and get a list of those that are from the same type (program database property) and finally get the one with the highest rank (also program property).
But the problem is that since the program related column is empty, it wont get anything from it! I use the program sold as starting point but how can I compare its property in the program table to get the good one? I tried a lot of formula with map() and let() and find() but it still using local data.
Thanks again!
I think you're trying to do too much by trying to cross reference everything through a formula. Once you figure out how to find what you're looking for between two database relations, then I'd work up to trying to connect the three together.
You can find how to find your "highest rank" through this video: ua-cam.com/video/H24ak0i0tAc/v-deo.html
You can find how to "count" by type through this video: ua-cam.com/video/JB4DX8XiykU/v-deo.html
Good luck!
@@NotionWorkflow Hi, thanks for reply! I just realize why it would not works. I just made some link between table but letting them empty. I though that I could access other table data even if the column is empty (like making a find() in the other table or so. I just found a way to relate everything without empty column so I can use data to access other table. Thanks again!
For filtering formulas of a single select (for me it's status), is it possible to filter using OR? I want to see Tasks that are either Ready or Today. Thanks for your help!
Glad I could help! Yes, you're spot on around using the OR function!
Great video
Thank you! 😁🙏
Hey can you do this using more than 1 relation?
Yes.
@@NotionWorkflow how please?
You'd create another relation property and adapt the formula to that relation.
Great stuff! Thanks
Bonjour y a t il des formules qui permet de faire la sum de sub-items ?
Yes! Since sub-items are just relations, we can use the formulas described in this video ua-cam.com/video/JB4DX8XiykU/v-deo.html
Parabéns pelo vídeo!
I am a school teacher wanting to convert my worksheets into Notion. Can I make a formula refer to a specific answer in another cell coming from a related table's data? In other words, I want to convert a simple fill in the blank worksheet into a table (questions) with relation column (answers in a separate answers table) and have a 3rd column (formula column) determine if the answer is correct and award points if correct as one might do in Excel e.g. IF(B2 = "photosynthesis", 5, 0)-- In this example
B2 is the answers selected from the choices in the answers column which happens to be a relations column to Answers table
Great question! The answer is you can and I made a video showing you how you can do that here: ua-cam.com/video/nU45U4oOXNE/v-deo.html
Great, heading over to watch it now, Thanks!@@NotionWorkflow
Got things up and running however, trying to see if there is a way to speed up the whole process of setting up assignments: I have it so that the student can select from a single select column of all the word bank choices. Yet, that is going to be time consuming- I have to set up the select options manually whereas I was wondering if there was a way to make it faster by just linking/pulling in all the select option from the existing Text colmn (Descriptions in your example) in the table from which the relation is being made. In other words, I would make a datatable with the Answers, and in the Questions datatable, set up the select choices by pulling in/pointing to the answers column. Hope that is clear: trying to not manually create my select option everytime I set up an assigment
I see what you're saying. I think what you could try to do is create a list of text for a word bank and then use the includes or match formula function to see if a property includes a specified value or matches what you're referencing.
The thing with that is that for every answer, you'd need to manually specify the answer, and you'd need to create a new formula for every question since you need to "check" if someone got that question right or wrong. What you could do is create a conditional statement that says, if question # is equal to 1, then test if this formula is true or not. I'd try creating 10 questions and 10 answers and see if you could create that first. Once you create a responsive set of relational databases, you can scale it and just create a button to create these sets of databases in one click.
You can find the syntax for match and includes here: www.notion.so/help/formula-syntax
Hope this helps!
@@NotionWorkflow Thank you. I am starting to let go of my idea for using Notion to handle scores as it has this strange inability to sum columns in any meaningful way beyond the Micky Mouse calculate tab at the bottom. I had a grand idea of using it to build my entire curriculum including lesssons, resources, assessments and grade book etc but alas it’s just not capable without some time wasting acrobatics. As well, the Ai (which I think is Claude-2) is so many orders of magnitude less intelligent than OpenAi that it foils my vision of an cutting-edge AI powered Learning Management System
Is there a way to let the formula property edit a different existing property (media property) ?
Also great video, makes everything more easier to understand!
Thanks! There isn't a way to manipulate another property through a formula, and I think what you're looking for would be some sort of automation through a third party program.
You could use a Notion automation to change certain properties through a trigger, but currently, you can't interact Notion Automations with formulas. Notion Automations don't support interactions with the media property either.
Hi there! Could you help me with a formula to sum the cost of sub-subtasks? I was able to come up with this so far: prop("Sub-item").map(current.prop("Sub-item").map(current.prop("Cost"))) - it will show the cost of the sub-subtasks (grandchildren) separated by a comma, but I cannot figure out how to sum it instead. Thank you!
Great question! Here is a video I made that goes over how you can do that. ua-cam.com/video/VLpj-4xEBuE/v-deo.html
Is it possible to make the formula smaller using "let" ?
Definitely!
Great video :)
I have a cell that contains a formula and is constantly changing its results. It provides data (more specifically, a date) based on certain conditions. I was wondering if it's possible to save its information (the values returned) in another cell so that when I apply a condition to this new cell, it returns only one of the dates kept. Your help would be greatly appreciated!
Just to provide some context, I'm working on a spaced repetition sheet, and I have a cell that displays my upcoming revision date. After completing this revision, the cell changes its date based on certain conditions from my previous review. However, I would like to retain all the dates of the revisions and later use this data to organize all the reviews I've done
I would use a Notion Automation and create a new database entry with said date when certain conditions are met. Formulas are not ideal for what you're trying to do.
Hey, thank you for the video. These formulas are a struggle, but you ade verything quite clear!
I have a question.. I am trying to set on my "left days" for a task that if a task has status submitted (with a formula when I put as a status "submitted" it automatically checks a box on the "done" column) it is completed. I don't like to have completed task (I still want to see them on the list tho) with 240days overdue.
Do you have any formula for that?
if(status=="submitted"..then what?
Thanks a lot
I'd use the ifs statement to make it easier on yourself. Ifs(status == "submitted", "", Status != "submitted", Days + "days overdue"). The key is just to create an output that is empty with two quotation marks, and then to precisely choose your output when it's not "submitted"
@@NotionWorkflow alright, I have tried inserting what you have said at the end of the formula I already had for the "days left" and I was able to get the word "complete" there. But how do I remove the "6 days overdue" that still shows?
The formula i am using is this one:
if(formatDate(prop("deadline"), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY"), "💥 DUE TODAY 💥".style("b","u", "orange"), if(dateBetween(prop("deadline"), now(), "days") > 0, format(dateBetween(prop("deadline"), now(), "days") + 1) + " Days Remaining", if(dateBetween(prop("deadline"), now(), "days") > -1, "❗❗ Due Tomorrow".style("b", "u", "yellow"),
if(dateBetween(prop("deadline"), now(), "days") < 0, format(abs(dateBetween(prop("deadline"), now(), "days"))).style("b", "red") + " Days Overdue ⭕".style("b", "red"), ""))))
+
ifs(prop("status") == "submitted", "", prop("status") != "submitted", "complete")
🙏
@@ellie1808 I'd restructure this into an ifs formula and start with the first condition that I mentioned. You'll just need to restructure the formula to match the ifs formula structure since you already have all the conditions. You can check out my video on that here: ua-cam.com/video/zkB0pW_k20w/v-deo.html
Good Luck!
@@NotionWorkflow will do, thanks a lot!
Could you tell me how I can indicate the next project in the formula when the previous project's status is completed and the name of the next project appears in the formula?
Don't think you can do that, unless you create a dependency with blocking/blocked by property and reference that relation within a formula property and it's related status property. You'd need to use a combination of a map and filter formula function.
@@NotionWorkflow thanks
I have a task data base and a project database. When in table view for my task databasse, I have a relational column with the project listed for each task. However, I would like the status(from my project database) and priority column(from project database) to be viewable within my Task database. Is this possible?
You could use the map function and do something like map("Tasks", current.status) or map("Tasks", current.priority). If you watch the video fully, you should find everything you need to know!
Can you help me,
How if i wanna show only date now,
I tried to change < to ==:
map(In.filter(current.Date == now()), current.Date)
But the formula didn't show anything.
You shouldn't use the "==" sign because date will never equal now(). Use month(), day(), or year() on top of the now()
I am trying to write a formula that will let me take my number of remaining classes divided by the number of remaining weeks to September 20th, 2024 to tell me how many classes I must complete per 1 weeks time. Rounded to the nearest tenth. I would also like to have a function that can adjust the rate based on how fast or slow I complete classes. This is what I have:
round((28 - length(filter(["status"], current == "Done"))) / dateBetween(now(), parseDate("2024-09-20"), "weeks"), 1)
But I'm getting this error:
Function round received unexpected argument. [115,116]
Please help! Lol
I'd remove the "round(" in the beginning and the ",1)" at the end and go from there. Good Luck!
26:00
3:18 🔖
Please work on your sound quality. It's very distracting...otherwise great video!
keep doing these videos man, super informative. very very helpful in better understanding the formula basics. i would like this video 100 times over if i could
Really appreciate it!! 😁🙏
So helpful!! Thank you
Thank you!! 🤗