Categorize If Project Completed On Time

Hi - I have most of the formula working below except for when a project is not completed yet and the Actual End Date is not inputted, and Helper (Difference in Days) is not calculated. When the Helper (Difference in Days) is blank, I wanted to Helper (Completed) column to pull "in progress"

Below is current formula with the part I need help with in yellow:

=IF([Helper (Difference in days)]@row >= 92, "3+ months over", IF([Helper (Difference in days)]@row >= 62, "2 months over", IF([Helper (Difference in days)]@row >= 32, "1 month over", IF([Helper (Difference in days)]@row >= 0, "within targeted month", IF([Helper (Difference in days)]@row < 0, "in progress")

Below is a screenshot of the sheet with column names:

Thank you for any assistance…. so close!

Find more posts tagged with

Formulas

Accepted answers

All comments

Ray Lindstrom

Hi @JNash,

Try replacing your formula in yellow with this:

IF(ISBLANK([Helper (Difference in days)]@row ), "In Progress", "")

BRgds,
-Ray

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.