-
Allow Grouping of Dates by Month/Year Year in Pivot Table App
I know we can achieve this with helper columns in sheets, but I think it would still be a game changer if we could design Pivot tables that allowed grouping/summarising of dates by Month/Year without needing to edit all the sheets to include a helper column. If we could do these sorts of date logics directly in the Pivot…
-
auto-populate date formula when column is checked
Hi All! I am looking for a way to add the date to a column when a check is placed in another column. I would want the date the check mark was added to the column. Any advice for the formula? Thanks kindly!
-
How to add varying months to varying dates?
I am really having trouble getting a formula to work here. I've gone through a number of support articles, but I'm just missing something. I want a formula that looks at Date Contract Executed and it adds Months Until Expiration to produce a new Date of Expiration. I've got my date columns as dates and the middle column as…
-
COUNTIF formula between date range
I'm trying to do a countif formula between a specific range of years, while referencing from an alternate sheet. This is the sheet with all my data (of course, just a small example) And this is the range within which I'm trying to work. For 1976-2000, the formula I have is =COUNTIFS({Game Design Range 2}, >=1976), but…
-
Formula that returns a value equal to every other day
Date formulas are the most challenging for me. The requirement is to provide a visual calendar that will trigger the quality audit team to complete the audits expected for the current business day. The sheet has three frequency options: Daily, every other day, and weekly. I am struggling to determine the formula for every…
-
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…