I'm trying to auto populate a column with Monday to Sunday dates based on date from another column.

Example "Current Date" Column "01/08/24" "Week Of" column would auto populate "01/08/24 - 01/14/24"

Current Date / Week Of

01/08/24 / 01/08/24 - 01/14/24

01/09/24 / 01/08/24 - 01/14/24

01/10/24 / 01/08/24 - 01/14/24

~

01/15/24 / 01/15/24 - 01/21/24

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!