dates
Discussion List
- Hi, Most of the time I use a different date format than the standard US default. When I edit a cell that contains a date, it is converted first to the default format. This makes it difficult to make s…
- Hello All, Having difficulty getting my formula to work properly when a column's value is "0". If the value is >0 it works fine. The formula is supposed to follow the WORKDAY variable and exclude week…
- Hi, I looked at the past discussion but didn't find the answer. My sheet has a row for each events happening with the precise dates (ex: 8-Aug-2024). I would like to count any event that happened with…
- Has anyone else noticed this week the calendar option in workflows had changed from a Sunday through Saturday format to a Monday through Sunday format? I had a workflow that sent out a notification wh…
- I need help coming up with a formula that enters the date in the date column any time an entry is made/ new line created. I tried the =(today) as a column formula, but every day it just updates all of…
- Happy August! This project plan was created using the Smartsheet PMO Template, which I have done many times before. How can I get the End Date in the first row to show the correct date (8/31/23), inst…
- Hi All, After new ew boardview upgate the date format changed to American. I've checked Account settings and those are correct as Australian which is 23/07/2024. When I go to Grid view I can see Austr…
- Hi, I'm trying to automate my start date and due date columns. In order to do this, I'm essentially hard coding the month and day piece of the function (e.g. "01/01") and then extracting the annual pi…
- I have a basic project tracker that has a due date column. I'm wondering if it's possible to also include a specific time to the field?
- I have a cross-sheet formula that adds the published date to my row. Once all the criteria are meet the row is then a workflow moves that row to the archive. But it doesn't seem to retain the Date des…