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.

Thank you.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!