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

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

Find more posts tagged with

Accepted answers

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

All comments

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! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.