-
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.
-
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…
-
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.
