-
Google calendar like option or work around?
Hey I have 2 columns that show different dates that I would want to see together in the calendar view. Has anyone figured out a work around for this or a clever formula to make this work? Hypothetically, for example: I would like to see the Packaging Release Date, Photography Shoot Date, and Copy due date.
-
Why is the Date function not working?
I want to calculate the first day of a month based on the "created date" column. I tried using Year Function to get the year, then the Month to get the month and last column calculates =Date(([Yearcolumn]@row),([Monthcolumn]@row),1) Yet I get the #INVALID COLUMN VALUE year and month formulas are set on number format What I…
-
SUMIFS Delivery Date >= Inventory Date
I'm attempting to write a SUMIFS formula where one of the criterion is to compare one date to another. It is returning 0 when it should return 1830. =SUMIFS({PURCHASING QTY EA}, {SHIP TO PLANT}, "HUBER HEIGHTS", {CONDUIT PURCHASING JDE CODE}, "RPVC0412200", {CONDUIT DELIVERY DATE}, >={CONDUIT INVENTORY DATE}, {CONDUIT…
-
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…