Hi
I want to know if there is a way, either through a formula or within Monday.com, where I can show the total value of multiple columns but only if they meet the criteria of a proceeding column (so very much like the SUMIF formula).
Not sure if that makes sense, to explain with better context (all relates to projects and payments)…
- We have a project worth £600k. The parent line has multiple columns to show progress of the project
- We use the sub items to show how the project will be financially billed. On this example we might have 4 sub items, each of £150k and one per month
- Each subitem has 4 simple columns. Application number, Forecast date, Amount and Status
- The Status column has 3 drop downs, forecast, applied and invoiced
- On the parent board I would like 3 cells, one for forecast total, one for applied total and one for invoiced total
- Within each of these cells I would like them to add up the total value of the sub items but only if the status is correct. So for example the forecast total should only include the sum of the sub items where the Status is set to forecast. To further elaborate, if I have 4 sub item entries, all of £150k each, 2 of them are set to forecast, 1 to applied and 1 to invoiced, then I need the value of the forecast cell on the parent board to only add the 2 items with forecast next to them, so it should show £300k
Does that make sense, and if so is there an easy way to do this on Monday.
Thanks all
