-
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…
-
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:…
-
How can I add days to a date field within a logic formula to output a true/false value for a chkbox?
My objective is to create a new column where a box is checked once the row meets desired criteria. The checkbox will help me filter-out rows that will be synced via a Salesforce Connector workflow. The logic criteria is as follows: "Overall Status" = Blue (complete)….and…. "Working Launch" Date + 7 Days </= Today's date…
-
Time and Date calculation
Is there a way to show how many hours passed from the time the form was submitted/created to the running/current time and date? I am trying to show the running hours lapsed while the entry submitted is still in the "Pending Status" I have the following column available I wanted to show the current duration in hours that…