Say I want to add another condition that goes: if property number is equal to 2 show me c. So it's grabbing now this property here: four is greater than zero but b would not apply because a comes first. Otherwise leave blank and two parentheses to close it out. Now, if I tick both of these, it will say "two." If I were to just tick one, it would say "one," so now we're adding Then, I'll close everything out - I'm closing out this function. I can also write "prop," and I can come into my properties here, pick one, and go "procedures," and it will finish the line for me. If you click on it, it'll give you that parentheses open. I can also add all of these together and go "unary plus," then "prop disqus" plus "unary plus."Īlso, when you go to type a function, it will show up here. If I do something like this - "prop," which is short for property - and I also give it two parentheses, and put the name of the property inside like "discuss," it will give us a zero because it is toggled "false." If I were to toggle it on, it would say "one." If I put in "false," it will give me zero as well. Going back to unary plus, I can also put in here something like "true," and that will give me the numerical value of one. Now if we were to go unary minus, which is another function, it will give us negative 42. The value could be like this example here - 42 - and it will give us 42 as a positive number. So you have "unary plus," and then the value inside these parentheses. What unary plus does is convert its argument into a number. We'll just leave it like this for now and add to it in a bit. I want a deadline date property, so let's put in some dates. Inline, create a table called "projects," and let's say there are three projects that we're working with. Now let's go down and create a projects database as well. Make it a formula, and let's put a percentage sign after this because that's what we're going to return - a percentage. At the end of this, we'll have something called "complete." We're going to have four different processes - discussion, procedures (these are the steps to get the task done), review, and finalize. In this tasks database, we're going to use check boxes. Let's go inline and create a table called "tasks," and call this task 1 just so we have a placeholder. We'll also see what formulas can do when rollups are in the mix.Įven though this is a singular use case, we're going to go through a ton of functions, including:įirst, let's create that tasks database. This template is going to be a project management dashboard of sorts - we're going to create a tasks database and a projects database, connect them, and see what we can do formula-wise. I don't want this series to be too dry, so by the end of this video, we will actually create something that is useful and can turn into a template that you can click on in the description. Hello, and welcome to an episodic series on how to use Notion formulas!
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |