Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
For example, today is 11/15, and first of the day (Monday) of this week is 11/13. How can I pick up 11/13?
Thanks for your advice!
Hello ysuzuki!
To write a formula that takes a date and then displays date of the Monday of that week, you can take advantage of the WEEKDAY() function which returns a number representing the day of the week, 1-7, where Sunday equals 1.
If you have a sheet where the date is in a column called Date and the formula is in a column called Monday, use the following formula:
=Date1 - (WEEKDAY(Date1) - 2)
For more information, see https://help.smartsheet.com/functions
Thanks!SchiffSmartsheet Support
Thank you Schiff! It worked like a charm!
