-
Min Collect Help - date returning zero value
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
-
Data Shuttle Date Formats - current crazy conversion
Need to be able to specify date formats in data shuttle OR for it to adhere to the formats in the uploading CSV file and/or smartsheet. For example: I have a CSV file to upload via data shuttle with date dd/mm/yyy. The smartsheet has the regional date setting of dd/mm/yyy BUT data shuttle takes a "best guess" and is…
-
Timeline View: Center on Today with Options for Visible Date Range
Timeline view is great. It has become our new favorite. One drawback is that it currently opens with the blue line (indicating today's date) way off to the left. Most of our projects have been in play for some time, and we like to see full bars in the visual, from the Start Date to the End Date. To accomplish this, we are…
-
Time columns from Excel to Smartsheet via Data Shuttle
I'm trying to Data Shuttle an Excel doc from another system into Smartsheet. All is fine, except for the Start Time and End Time columns. They look like this in Excel: But when I pull them into Smartsheet via Data Shuttle, the columns show only the date part of those columns: I'm really only interested in the time…
-
Merged: Change default date format for the organization
This discussion has been merged.
-
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…
-
Merge Date and Time, then calculate hrs remaining
Looking for your help, so we have a project manager that has the below information on a sheet. And what he is looking for, is to have a column that calculates how many hrs left each row has before it reaches its planned end date/time. That way they can either add filters or conditional formatting for the rows that are due…
-
Formula to calculate a future date on a specific day (monthly and quarterly)
I have tasks that need to be completed monthly and quarterly. The due date of these tasks falls on specific days of the month, either the 5th, 14th, or 15th. I have a formula that calculates the Next Date based on a Due column and a Frequency of Submittals column. Next Date and Due are date columns. My basic formula to…
-
Pull date from text string for conditional formatting
I have a text string column that always ends with "by [date]" on a sheet that someone else manages. They want to keep the text in that paragraph instead of using a separate date column, but they want conditional formatting on the date column… I have a formula that pulls the text value from the Next Deliverable(s) column:…
-
Systems and Services subscription renewal dates
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 charges at first, but then have that date push out to one year (or month if it's monthly). A notification email would then get…