Hello I need 2 formulas please to calculate (1) the first working day of a month So - 1 December 2024 is on a Sunday, I want the returned date to be 2 December 2024. 1 November 2024 is on a Friday, I …
I have a sheet which tracks the various systems we use and their monthly & annual subscription charges. We'd like to have SS tell us when a renewal date is approaching, particularly with the annual ch…
I'd like to populate the due dates for child tasks based on the 'master' due date of the parent line, with the help of a "days out" or "weeks out" column. For example, I'd input the due date of the pa…
We have a form that has a DATE field called "Need Order By" so that the user can tell us the date the the order must be fulfilled by. Can you guess what date users MOST OFTEN use? Yeah, you got it! a …
So, I have a column where I can predicted dates (to pay an invoice). Some of these values are past the predicted date of payment. Therefore, I want to make a formula that will capture all those whose …
I have a form for requesting email sends and I wanted to know if I can "block" some specific dates so that requesters cannot make requests on those days. Is it possible?
I have a form that my colleagues request emails to send to my marketing team and it would be nice if I could prevent requests from specific dates in the form
Hello, I am a project manager in the acquisition space and am creating a project tracker in SmartSheet. One column contains the days +/- from the close date that a task needs to start and another colu…
I have a due date (e.g. 28/10/2027) and id like to be notified 2 years before the date. As smartsheet only allows me to set an automation 365 before a due date, I made a helper column which would brin…
Hi, I am trying to create a formula with dates that will change each month to the start and end date of the new month, so I was hoping that I could link the start and end dates to a cell in the Smarts…