I was searching in to other discussions and apps on the marketplace but haven’t found answers similar to mine.
Here’s the scanario:
I want my column to increase each time a new item is being added— which is time dependent. The increment of the increase is a constant value.
Example:
Date
Weekly Target
Weekly Actual
Cumulative Target
Cumulative Actual
03/03/2025
5
2
15
11
03/02/2025
5
6
10
9
03/01/2025
5
3
5
3
The Weekly Target is set to 5. After a new Weekly Actual item added, the Cumulative Target column should update to 10, 15, 20… so on and the Cumulative Actual column should do a running count as well based on the Weekly Actual.
Has this been asked before? Please point me to any lead.
You can’t do this with a formula column because formulas can’t reference other rows.
The best way is to use an automation that updates the Cumulative Target and Cumulative Actual every time a new item is added. Set it to add the new Weekly Actual to the previous total.
If automations don’t work, you might need to use Google Sheets or another tool to track the running total and sync it back.
Let me know if you need help setting this up.
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
3
You can do this with the Advanced Formula Booster as it allows you to create formulas involving any item (previous/next/subitems/items in the same group/items in the same board).