Copy if a week is complete

Sylvia Elizabeth

Hi,

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.

Bassam Khalil

Hi @Sylvia Elizabeth

am sorry i make a mistake because the ( Estatus semana anterior ) isn't Date type, please check the following formula and i create a sample sheet for you you can test the soluation:

=IFERROR(IF((TODAY() - [Created Date]@row) >= 7, Estatus@row), "")

the following is a link for the sample sheet you can test it:

Bassam Khalil

Hi @Sylvia Elizabeth

Hope you are fine, to do that you need to add "Created Date" column then you can use the following formula in "Estatus semana anterior" column:

=IFERROR(IF(TODAY(7) >= Created@row, Estatus@row), "")

and convert it to Column formula

Sylvia Elizabeth

Hi @Bassam.M Khalil

I think it doesn't work that well because even if I change the date it stills remains the same status, it doesn't changes into blank or something if the week is or not completed.

Do you know why?

Bassam Khalil

Hi @Sylvia Elizabeth

am sorry i make a mistake because the ( Estatus semana anterior ) isn't Date type, please check the following formula and i create a sample sheet for you you can test the soluation:

=IFERROR(IF((TODAY() - [Created Date]@row) >= 7, Estatus@row), "")

the following is a link for the sample sheet you can test it: