Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Create field showing total rows in another table?

2558 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Craig_Mohr
4 - Data Explorer
4 - Data Explorer

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?

3 Replies 3

Hi @Craig_Mohr - in your tasks table you can create a “counter” of not completed tasks:

Screenshot 2019-12-15 at 13.53.19

This uses the formula:

IF(Completed, 0, 1)

Then back on your projects table sum up this column with a rollup field:

Screenshot 2019-12-15 at 13.55.08

JB

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?

@Craig_Mohr, yes, try this:

On the tasks table, create a formula field with formula:

IF(NOT(Completed), Name)

Screenshot 2019-12-18 at 20.40.14

Then on the Projects table, look up this field:

Screenshot 2019-12-18 at 20.41.42