Finding the sum of a particular column based on the status of the task

1

image

I need the sum of expenses on tasks that are ‘Completed’ & ‘In Progress’ , please share the formula on how this can be done.

2

Dear @VINAY_B_C ,

You might want to check out this video from @maria

1 Like
3

Hello @VINAY_B_C

It helps if you share your document or share a dummy document with a copy of this table. What you want is really easy in Coda, and if we can show you in a document it is really easy for us to show you the answer.

The formula you need is going to look something like:
RENOVATION.filter(status=“COMPLETE”).amount spent.sum()

I prefer to have the STATUS column filled with objects from a lookup table, but that is up to you. Again, if you share a document, we can show you.

Greetings, Joost

4 Likes
4

Hey Joost, thanks for helping out, the formula worked.

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.