Week Of Date Formula ( Week of 2/6)

Theresa Freeman

I want to be able to filter all the jobs per the week; Week of function.

Example: Week of 2/6 would automate for any jobs that has a start date between 2/6 and 2/12)

In excel the formula was =IF(G12<G12-WEEKDAY(G12-1),G12,G12-WEEKDAY(G12+7)+1).

How do i convert that to a Smartsheet formula?

(G12 in Smartsheet is _Project Start Date)

Find more posts tagged with

Accepted answers

Sameer Karkhanis

The WEEKDAY function works the same in Smartsheet so you can literally copy the same formula and replace G12 with your column name

=IF([_Project Start Date]@row <  ([_Project Start Date]@row - WEEKDAY([_Project Start Date]@row - 1)), [_Project Start Date]@row, ([_Project Start Date]@row - WEEKDAY([_Project Start Date]@row + 7)) + 1)

Btw, make sure that the column where you are using this formula is also a date column (aka column property is set to Date)

All comments

Sameer Karkhanis

The WEEKDAY function works the same in Smartsheet so you can literally copy the same formula and replace G12 with your column name

=IF([_Project Start Date]@row <  ([_Project Start Date]@row - WEEKDAY([_Project Start Date]@row - 1)), [_Project Start Date]@row, ([_Project Start Date]@row - WEEKDAY([_Project Start Date]@row + 7)) + 1)

Btw, make sure that the column where you are using this formula is also a date column (aka column property is set to Date)

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.