Copy if a week is complete
Im trying to come with a formula which can identify if a week is complete or over, so then put or copy the status of the column "Estatus" into the column "Estatus semana anterior". I would like to automate the column to track the progress of the previos week without having to type it manually in "Estatus semana anterior", and in that way I would only have to update everyweek just the column "Estatus".
Is this possible?
Hope you can help me.
Help Article Resources
Check out the Formula Handbook template!