Calculate a review date but only if %Complete is 100%

Pam Bussing

Hello,

I have an "End" date column and I can calculate out 12 months using:

=[End]@row + 365

However, I would like to have this date populate the cell only if the "%Complete" cell, in the same row, is 100%. In other words, the cell will be blank unless the task is 100% complete.

I tried the following but get the parse error.

=IF([%Complete] 9 = "100%", [End]9+365)

=IF([% Complete]9 = "100%", End9 + 365, "")

I definitely need help!

Pam

Andrée Starå

Hi Pam,

Try something like this.

=IF([%Complete]@row = 1; End@row + 365)

The same version but with the below changes for your and others convenience.

=IF([%Complete]@row = 1, End@row + 365)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Hi Pam,

Try something like this.

=IF([%Complete]@row = 1; End@row + 365)

The same version but with the below changes for your and others convenience.

=IF([%Complete]@row = 1, End@row + 365)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

To add: Percentage is written as:

1=100%

0,1 (0.1) = 10% and so on

Pam Bussing

Thank you! And for the very fast response. I appreciate it.

Andrée Starå

I'm always happy to help! 👍️