-
Populate Child due dates based on parent due date and (+/- number of days) column
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 parent line below as December 31st, I'd want the child lines to populate accordingly with December 31st less the number of…
-
Form: Require "Need order by" field to be AFTER today.
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 date in the PAST. We are very anxious to find a way to force the user to input a date that is in the FUTURE. Can anyone tell…
-
Trying to capture past dates and future dates
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 date is in the past and those invoices whose predicted pay day is in the next 30 days. So far, I am only able to do :…
-
Block Dates
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?
-
Block Dates on Forms
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
-
Formula Question - Integration Project Management Tracker
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 column that contains the days +/- from the close date that a task needs to end. How can I create a formula that will take the…
-
How can i make an automation to notify me 2 years before a due date?
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 bring back the date i should be notified. I used the formula below but i get an error. =DATE(DAY([Due Date]@row), MONTH([Due…
-
IFS statement with a date from another cell
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 Smartsheet which have the correct dates and will be easy to update rather than changing each formula each month, but when trying…
-
I fixed my issue but why? - Notification email delayed by 1 day
I have a sheet that notifies people when they need to review a document based on when it reaches its expiration date. The idea is that people are sent an email notification 90 days, 60/30, and 7 days before it expires so they can take action. I have the date the document expires in one column and in another column, I have…
-
Regional Format Dates for Forms / Document Builder
Hello, When creating Documents in Smartsheet or capturing data through Forms, Smartsheet currently processes dates in the background in the US in American format. Ideally, once processed, the output is in the regional settings of the Smartsheet instance. Why? Documents generated by "automations" will result in American…
