-
Dates imported from Excel in YYYY-MM-DD are interpreted incorrectly
I am attempting to paste or import data from Excel. I formatted dates in the ISO standard YYYY-MM-DD to prevent any confusion over which part is the month and which is the day. Yet, when I paste or import this data to Smartsheet, it interprets the day and month wrong whenever both are below 12. Copying from Excel: When…
-
Due Date based off a workday schedule - Need Workday Formula Help
Hello everyone. I'm trying to use a WORKDAY formula to auto-update a list of due dates. We have several financial tasks that must be completed a specific workday every month. For example, the books need to be opened -1 to the start of a new month. But this needs to be a workday. I have been trying to setup the formula so…
-
How do I get a date value to show/change in a dashboard?
I have inherited and existing Smartsheet, which I am just learning. The dashboard has a metric widget with a week of, but it does not change we are stuck on one week. I have a column that is now labeled as "Week Of" the cells show the date as 07/28/24 and the column type has been changed to date. How do I go about setting…
-
Need the minimum start date for projects, what's the formula?
I'm trying to get the formula for the min start date based on the project number. So in the chart below the minimum start date for project 1 should be 11/5/24.
-
Bring back date picker in schedule view Resource Management
The date picker to the right of the date slider to zoom in and out has disappeared recently. This makes it very difficult to move forward in the schedule view if you need to navigate to a date in the far future. When the feature was still there you could simply click on the future date, now you have to long click and drag…
-
Count # of cells approaching a date for sheet summary
I'm trying to create a sheet summary field that counts the number of cells in a column that are less than a week from the date in the cell. This is what I've tried: =COUNTIF(Off-Site to On-Site Return Estimation:Off-Site to On-Site Return Estimation, TODAY(<7) Thank you for any help!
-
Snapshot of Smartsheet comparing TODAY to Start and End Dates
I have a grid sheet full of contracts: each row is a contract. Each row has a START DATE and END DATE along with other details about the contract. I was tasked with creating a dashboard to represent this grid sheet over time. I am now creating a reference sheet to pull "snap-shots" of data from the grid sheet. I put in a…
-
Calculating Next Monday, Wednesday, Friday
I'm trying to write a formula to calculate the next monday, wednesday, and friday following a particular date. The AI formula generated =IF(ISDATE([Start Date]@row), [Start Date]@row + (8 - WEEKDAY([Start Date]@row, 2)), "") using the example above; however, it generated an #INCORRECT ARGUMENT error. The expected results…
-
Formula to bring back the 3rd Friday of next month
I need to calculate the 3rd Friday of each month consecutively on a sheet. I am looking for a formula that will take the date of the previous line and spit out the next month's 3rd Friday, in sequence. Any help would be very appreciated! Thank you.
-
Count if Between a date range
Morning Smartsheet community, Hope you all had a great festive period. I'm struggling with a formula that would make my reports a whole lot easier….. I have a helper column that I want to return a value@row could be anything but for ease say "1", If the date in the [Form Date]@row is between the dates set in [PP Dates]1…