Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 13, 2019 11:04 AM
I would like to create a cell for a project page that summarizes the total number of open subtasks which are stored in a separate table in the same base named for the project. For example main page “projects” with a row “o365 migration” one of the cells on this row is “subtasks” another table called “o365” with multiple rows with individual tasks. Not every row would have subtasks, just major projects. Ideally it would only count rows not marked as complete. Is something like this possible?
Dec 15, 2019 05:55 AM
Hi @Craig_Mohr - in your tasks table you can create a “counter” of not completed tasks:
This uses the formula:
IF(Completed, 0, 1)
Then back on your projects table sum up this column with a rollup field:
JB
Dec 16, 2019 05:50 PM
Thanks this helps. I’ll have to look at the rollup field and see how it works. Is it possible rather than list all the tasks to instead just give a count of the number of tasks?
Dec 18, 2019 12:42 PM
@Craig_Mohr, yes, try this:
On the tasks table, create a formula field with formula:
IF(NOT(Completed), Name)
Then on the Projects table, look up this field: