I have figured out a way to do this - this being a row level calculation done from an automatization rule.
(Practical example, increase the startdate on a daily task once every day)
I have not been able to isolate a specific row from the automation rule. Everytime I access “Start date” from the automation rule builder, I get back the list of all start dates in the table. I cannot use ThisRow, because when I use ThisRow, I am not able to link it to a specific column. (I also found out that one does not seem to be able to manually write the formula, it needs to be built using the drop-downs and the tab. (Or Click))
What I ended up doing, is to create a button with the formula “Start date = Start date +1”. Then I have an automation rule to push the button early in the morning.
What I still have not been able to do, is to add the value in the “Duration” column to the “Start Date”. So I will have to write separate buttons for daily, weekly increases, and add an indicator column to distinguish between daily and weekly tasks. Monthly and annual changes will take some more coding to adjust for the number of days in the month. or days in the year.