Hello Formula Gurus!
Do any of you have a formula that will return the "week starting" date based on a created date? So evaluate the created date of a row and bring back the date of Monday that week.
=IF(WEEKDAY(Date@row) = 1, Date@row - 6, Date@row - (WEEKDAY(Date@row) - 2))
Here's what I got to work:
=Created@row + (2 - WEEKDAY(Created@row))
Where "Created" is the Created Date Column.
Let me know if you need any further assistance!
@Leibel Shuchat Beautiful! Works exactly as I wanted. Thanks much!
@Jon Mark H that works too! 😊
Glad to help!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
Hi There I am using the below formula to check a box if a date is one day greater than today. The formula works fine except if the date field is blank, then it is showing up #Invalid Data Type. How can the results show up as blank instead of #Invalid Data Type if there is no date referenced yet? =IF(NETDAYS([Date to…
I have an intake form where we receive campaign budgets. We are trying to track when our campaigns as a whole start spending over our expected Overall Budget. I need a column formula that can calculate the remaining budget when a new campaign is added. Currently, the intake form is set up to have new campaigns be added at…
©2024. All Rights Reserved Smartsheet Inc.