Week Number stopped working

Hi All,

I'm a little stumped, I have a formula that worked great until last week when it stopped working. I figured it was just because it was week 1 and week 52 in the same week and figured it would all start working this week. No dice, any help is appreciated.

The formula is a helper column that is meant to count the number of installs per week.

=IF(ISBLANK([Date AP Patched (Vendor)]@row), "", IF(WEEKNUMBER([Date AP Patched (Vendor)]@row) <= WEEKNUMBER(TODAY()), WEEKNUMBER([Date AP Patched (Vendor)]@row) >= WEEKNUMBER(TODAY() + 1), 1))

Find more posts tagged with

Formulas

functionality

IT & Operations

Project Management

Accepted answers

All comments

Ezra

One way I dealt with the Week Number being screwy was to check the month of the date. Smartsheet seems to push the last few days of a year into the week 1, if the first of January is anywhere in that week (haven't tested on weekend conditions).

This builds a year and month number with consistent decimal placing of the month.. i.e. 2020.05 instead of 2020.5

=IFERROR(IF(AND(MONTH([Task Start]@row) = 12, WEEKNUMBER([Task Start]@row) = 1), YEAR([Task Start]@row) + 1, YEAR([Task Start]@row)) + "." + IF(WEEKNUMBER([Task Start]@row) < 10, "0" + WEEKNUMBER([Task Start]@row), WEEKNUMBER([Task Start]@row)), "")

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.