How to do incrementing columns?

Platform discussions Special workflows & use cases
, , ,
1

Hello!

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.

I appreciate all the help. Thank you.

2

Hey there!

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.