formula task count #638
-
|
Is there a way to get a total for tasks todo/completed for a file? I know the rollup allows it, and I can have a list of the tasks but I just want the number. My guess is a formula could do it but I am not sure how. |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 5 replies
-
|
There is not a direct way to obtain that number, but you can use dataview ${db.dataview.page(row.__file__.path).file.tasks.length} |
Beta Was this translation helpful? Give feedback.
-
|
ooh ok. I didn't know we could do that in the formula box. The formula property seem extreamely powerful but very confusing 😆 |
Beta Was this translation helpful? Give feedback.
-
|
yeah, its designed to run javascript. You can really do whatever you want inside. Over time we will add syntactic sugar to make it more friendly |
Beta Was this translation helpful? Give feedback.
-
|
is it a case of learning js for using the formula box right now? |
Beta Was this translation helpful? Give feedback.
-
|
with very basic cases it would not be necessary but if you want to start doing complex things you have the option with js |
Beta Was this translation helpful? Give feedback.
-
|
if i want it to measure todo tasks, how would i edit it? |
Beta Was this translation helpful? Give feedback.
-
|
You can check the dataview API info. In your case: // ...
file.tasks.where(t => !t.completed).length |
Beta Was this translation helpful? Give feedback.
There is not a direct way to obtain that number, but you can use dataview