Behind/Ahead of Schedule by "x" days

Hi All,

I'd like to add a column that reflects how many days my project plan is ahead/behind schedule. I asked this question last year, but couldn't find it anywhere.

I have a Planned Finish and a Finish Date.

I'd like the row to display the following for each:

If no variance, display "On Time"
If late, display " X days Late"
If early, display "X days Ahead".

Thanks!

Find more posts tagged with

Formulas

Reports

functionality

Accepted answers

Paul Newcome

Try something like this...

=IF([Finish Date]@row > [Planned Finish]@row, [Finish Date]@row - [Planned Finish]@row + " days Late", IF([Planned Finish]@row > [Finish Date]@row, [Planned Finish]@row - [Finish Date]@row + " days Ahead", "On Time"))

All comments

Paul Newcome

Try something like this...

Elizabeth Jones

Beautiful! thanks so much :)

Paul Newcome

Happy to help! 👍️

Sandra Guzman

I am glad that I found this discussion - it's exactly what I was also looking for!

I am using the above formula and wanted to know what I would need to adjust in the formula so that the field is blank until the End date is entered. I replaced @row and entered the row number... but each formula I used still displays "day Ahead" in each field where a task has not yet been started. I want to try to avoid having text in these fields.

Thanks!

Sandra

Paul Newcome

@Sandra Guzman

Try something like this...

=IF([End Date]@row <> "", above formula)

This will only run the above formula if the End Date is not blank.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.