-
Using a date range to define a planned Sprint name
I want to use a Start Date to determine which sprint a ticket will be identified with. For example Sprint 17 starts on 08/13/25 and ends on 08/27/25. If my Start Date is within this range then I want to output the Sprint Name into a Planned Sprint column. =IF(([Start Date]@row >= "8/13/25", IF(AND)([Start Date]@row <=…
-
PMO Metadata is showing invalid after I removed 1st row of the project intake sheet
I made a mistake, The intake sheet had the same row listed twice, the main row and row 1, I deleted row 1 and now my project metadata is now broken. Help!!! Thanks
-
How to automatically consolidate data from sheets in multiple workspaces into a single master sheet?
Hi Our structure is such that we create a new workspace for each project that we sign on. Within each workspace, lies a sheet with assignee name(s), department(s) and start/end dates for the project. We want to roll up the data from across all project workspaces into a single master resource tracking sheet, and keep adding…
-
Smartsheet Being Slow
A few counterparts and I have been experiencing Smartsheet loading slow, spooling for excessive amounts of time, or taking a while to refresh. It doesn't matter what type of file we are working with (sheets, dashboards, reports, etc.) we get the same experience. We have tested this on various Wifi's with the same results.…
-
How can show difference in answers on same questions in separate sheets?
I have many categories that each have several statements. Each employee will be sent their one sheet and either agrees or disagrees with each statement. Their manager will complete the exact same sheet about the employee. I want the manager to have a report that displays the category and statement where their employee and…
-
Does the change in value within a formula not count as a change?
I'm trying to create an automation. In this automation, I want to copy rows when a value changes based on a formula (a count from another sheet), but the automation isn't triggering. What could be causing this issue?
-
Disappearing Links
I had several links (URLs) saved in a sheet for quick access to frequently used resources. All of the links (URLs) have disappeared. Many links were to Google Drive resources. What caused the links to disappear?
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
Employee Reviews - Pulling & Averaging Category Scores
Hi all, thanks in advance for your assistance! I am working on building a new employee review process for my company and am caught up on one of the final steps. Here's where I am at: I have created an employee review form that individual managers will complete Each employee will have 3-5 reviewers The form submissions will…
-
SIMPLE Conditional Formatting is not Working
I have never had issues with conditional formatting, even when formulas were required. This one is simple, it is NO formulas, just based on the user's selection from a dropdown that appears in this sheet. The first screenshot shows the column example. Most are declined here, and those should be highlighted ORANGE based on…