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 ki…
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 …
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 ra…
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. Th…
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 im…
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 ne…
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 label…
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.
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 …
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…