-
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…
-
Automation to record a date isn't working
I'm hoping someone can help. I've used Smartsheet for years (at another company) and have never ran across this. I'm trying to record a date when the status changes to "1st Review". I have even gone so far as to create test columns where there is nothing, no formulas, conditional formatting, etc. attached, toggled Date…
-
I would like to express the date changed from the reference date as Gantt View
If you set a final date (24.11.21) and entered a few days over a period of time, you must check the date backwards (24.09.22). Currently, only dates with additional time are displayed (25.02.12).
-
SumIfs function with a date
Hello! I have a sumifs formula that works great: =SUMIFS({Amount}, {Branch Number}, Label@row, {Request Type}, "Maintenance") My problem is when I try to add a date aspect to this formula. I want to break this number down by month, so how much was spent at a specific branch by request type and month. I added this formula:…
