-
Filter option for all Incoming Dates (or Outgoing Dates)
It'll be super helpful for our Schedule Owners to have Filter for all Incoming (or Outgoing) dates when they have many incoming dates in their schedule. (Sometimes those are start dates… but some are in deadlines etc. ) I know if we add helper column to capture that we can do that, but it adds additional steps and more…
-
Restrict number of times date is allowed to generate?
I am looking to formulate a column to generate a date based on the submission date and turnaround time of the type of task. However, we only want to allow each date to generate up to three times. If that date reaches a fourth date, then we want it to add a day to the generated date. Example: Doc1 received on 2/24,…
-
Date Range in Date Column + Automation
Hello! I have an automation that currently sends users alerts based on the date in a column called "End Date". A majority of the time, the end date is a single date. However, sometimes the end date can be two or more days (ie- May 7th-8th). While I can write into the date column ="May 7th-8th", that will prevent my…
-
Return a date or month
Hello! Is it possible to write a formula to get the following result - Start Date Column: if it's a confirmed date, a date two weeks earlier in a photography due date column is calculated (this works by using this formula: (=[START DATE]@row - 14)) HOWEVER, if a start date is TBD and I put in the Start Date Column "March…
-
Date Format Options within Dynamic View Details Panel
Would like the option of utilizing different formats for entering date values within the Dynamic View details window. Currently the only option is a standard MM/dd/yy. When non-tech users enter birthdates etc. they often enter the last 2 digits for the year and the date defaults to 2000's creating issues. As an example…
-
Error when refrencing a date column in formula
I am attempting to change the Fabric status column based off the dates in Fabric A,B,and C received date columns. I want to return a value of Received in the helper column if there is a date in Fabric A received date, unless 2nd fabric required is checked, then Return the value of Received when there is a date in both A…
-
Dynamic Date Calculations
We have different project types, and each project type has a different number of days is needed to complete a task. We have a sheet of about 30 rows that defines based on what project type, how many days it takes to complete the task. I want to make a date column to say "this is when this task is due" but I'm not sure if…
-
Wrong date pasted when copying "Created date" to "Date" field in Report
Scenario: A sheet used to track customer request fulfillment has both a manually entered "Date" field and an automated "Created date" field. The idea being if needed, you could enter records after the fact and still track the correct date for reporting. The data needs cleaning. I created a report for staff to easily see…
-
Dates are formatting in 2 different ways on the same sheet
Is this a Smartsheets bug? My formula is simply concatenating the date with the time. This seems to happen randomly when smartsheets updates itself, and it fixes itself only when I re-save the sheet. Our Windows OS date settings are set to American format mm/dd/yyyy, but our smartsheets are set as dd/mm/yy Is there any way…
-
Question on DATE(x) function referencing another location for date instead
Question: I wanted to see if there is a possibility to reference the begin date to end date from another cell instead of inside the formula. MY attempts to use a reference to another location has failed. For Example: DATE([8]1) instead of DATE(2024, 12, 31) Syntax I am using. =SUMIFS({GL Datasheet_Amount}, {GL…