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)

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)

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)