-
Editing a date item is not in the same format as the column format
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 small adjustment manually because the day, month and year is in a different order than what I see all around. See this…
-
Workday formula doesn't calculate correctly when value is "0"
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 weekends, which it does unless the value in the [Days to add] column is 0 at which point it seems to ignore the workday rule.…
-
Counting number of events (lines) within a time range
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 within a time frame (march 1rst to march 31rst of the next year). I tried various formulas but no luck at all…
-
Workflow Observation
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 which is scheduled to send out the end of the month on day 25 - 29, today is 8/8/24!! Upon checking to see why it ran I…
-
How to create a formula that logs the date the row was created
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 the dates to be whatever day it is, and not the date that the row was created.
-
PMO Template Project Plan not displaying correct End Date at top row
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), instead of 8/17/24? It's not rolling up. Thanks in advance for your help.
-
New Boardview
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 Australian date format but on boardview is American. How can I fix board view to show Australian date format 23/07/2024. Thanks…
-
Formula Date Not Syncing With Conditional Formatting
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 piece of the function from the Task column (e.g. "2024" to "24"). The output, I believe, is similar as it would be in excel…
-
Can I add a time do a date field?
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?
-
Date from a Cross-sheet formula not converting to a Date when row is moved #Invalid Type Error
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 designation once it has been moved. I was having issues with a countifs formula that was looking into the archives for items…