Populate "Week of" based on Date entry

PreetyK

I want to auto populate "Week of" column based on the entry in "Date" column. If I enter "01/01/2025" in the date column, then the "Week of" column should populate "Week of 12/30/24" which is a Monday of that week.

KPH

You can do some math using the WEEKDAY function.

If your Smartsheet is set up with the weeks beginning on a Monday this formula should work:

=Date@row - WEEKDAY(Date@row)

If you have the week starting on Sunday, you will ned to add one day

=Date@row - WEEKDAY(Date@row)+1

Hope this helps.