I am adherent to Marshall Goldsmiths daily questions. This means today I have an excel spread sheet with a list of questions that I answer every day with a value of 1-10. At the end of the week I have the average of the week and compare it to the week before.
Today I do this in google sheets and every Monday I make a new copy of the sheet, copy the weekly average to the previous weeks value column, delete all the values and start over.
I am convinced Coda can make this automatic and allow me to have much greater value than just a week by week view, but I am stuck. The automation seems limited. I would love to recreate my manual steps of creating a new table every week and the copying of items, but automations doesn’t seem to be able to do this.
I would love thoughts or suggestions. Maybe I can add new columns for the new week and auto hide columns and move around my average and last week information?