Hi Maciej, I’m not too sure whether I understand the problem correctly. Could you tell me which of the two below is the one we’re trying to achieve please?
We only want last week’s value, where it would look something like this:
We want all of the previous week’s values, added together:
Once you’ve confirmed which option it is I’ll figure out how to automate it
Both of these can be found here
To view the formulas, duplicate the base by clicking the title of the base at the top of the screen, then the three horizontal dots on the right, and then the “Duplicate Base” button.
Roger that. The idea is to:
Only last weekfield)
Last week's valuefield)
If you’re alright with it, you can do this manually by linking last week’s record to this week’s record.
If you want it to be automated, then you’ll have to create a system to find last week’s record by linking all of your existing records to one record and using
I’ve updated the original base with just such a system and automation. I’m unsure if this is what you’re looking for; let me know if it is and I’ll answer any questions you have.
(You could also accomplish this via a script, but you’ll need a Pro account and someone that can write the script for you; I can help with this as well if you need it)