Display Progress Completion

I have two tables, “Projects” and “Tasks”. I need to display the completion status of the tasks in the “Projects” table.

In “Tasks”, I have a single select dropdown with “Not Started”, “In Progress”, and “Completed”. I would like to display the “Progress” in “Projects”. It should say “1/4” if there is one “Completed” and 4 tasks.

The formula in Excel is “=CONCATENATE(COUNTIF(Sheet2!A2:A5, “Completed”), “/”, COUNTA(Sheet2!A2:A5))”

Please help me find out how to do this in AirTable, thanks!

Hi @Ray_Li - try this:

On your tasks table have a formula field:

IF(Status = 'Completed', 1, 0)

Back in the projects table you can do a rollup on the Status Value and count the number of tasks:

The final step is to concatenate the two values together to get the string output you want:

{Status Rollup} & '/' & {Count of tasks}

Obviously, hide any fields you don’t want to be displayed.


1 Like

Thank you very much, that works!