Formula for status update using number of workdays until finish

I need help with a workday formula. I'm trying to get my status bubbles to update automatically based on the number of days until task completion. I've got it to work counting backward using all days with the formula below, but I can't figure out how to only count workdays. Any help is appreciated.

=IF([% Complete]@row = 1, "Blue", IF(TODAY() > Finish@row - 3, "Red", IF(TODAY() > Finish@row - 7, "Yellow", IF(TODAY() > Finish@row - 8, "Green"))))

Find more posts tagged with

Accepted answers

Lucas Rayala

I believe you can just use WORKDAYS.

IF(TODAY()>WORKDAYS(Finish@row, -3), "Red")

All comments

Lucas Rayala

I believe you can just use WORKDAYS.

IF(TODAY()>WORKDAYS(Finish@row, -3), "Red")

Aloysius.Kling

Thanks Lucas. I had to change it to WORKDAY instead of WORKDAYS, but your suggestion worked.

=IF([% Complete]@row = 1, "Blue", IF(TODAY() > WORKDAY(Finish@row, -3), "Red", IF(TODAY() > WORKDAY(Finish@row, -7), "Yellow", "Green")))

Lucas Rayala

Glad you got it working!

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.