How to do incrementing columns?

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:

DateWeekly TargetWeekly ActualCumulative TargetCumulative Actual03/03/202552151103/02/20255610903/01/20255353

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 replies