-
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 <=…
-
formula to return what day of the week a date is?
in Excel this would be the formula =CHOOSE(WEEKDAY(A1),"Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat") Does not work in SS?
-
What's wong with this formula?
=COUNTIFS({Master Project List Range 1}, "2 - Construction", {Master Project List Range 2}, <= EOMONTH [Month]@row , 0, {Master Project List Range 3}, >= [Month]@row ) I can't understand why I'm still getting an error message that this formula is unparseable. I'm trying to create a table that counts how many projects are…
-
Using index/collect formula from another smartsheet
I am trying to use index/collect to enter an email address located in another sheet. Source Sheet is Database Macro_2025: Target Sheet is Delinquency Report: Using 75033 as the example from the Source Sheet. I need the email for the Accountant of Customer ID 75033 to be entered in the Finance Contact Column AND General…
-
IF/THEN Formula or Conditional Formatting
I think ultimately I need a formula but will start to see if conditional formatting will work. We have a sheet where if a condition in a cell is true, then we want cells in that row to be shaded out. So if the Doc Type = Form, we want the 3 different quiz cells to be shaded grey and the rest of the cells to be left blank.…
-
Multi Select
I have a multi select drowndown with users. (for example: Bill, Joe, Ted, John, and Tom) are selected. I am trying to look in another sheet to tell me if these people have submitted a status for project 123. (Sheet 2 is a list of status's submitted: Project | Submitted by | Status 123 | Bill | Green 123 | Joe | Green 123 |…
-
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…
-
Auto Fill Date When Column Checked
I want my date column to auto fill when I check the column Verification and Closure. What formula do I use? I want to ensure that the date doesn't change as time goes on.
-
Convert Column to Formula Error
Hi! The following formula calculates just fine in each cell but when I try to apply it to the entire column via the Convert to Column Formula, it's not working: =IFERROR(WORKDAY([Date Submitted to Courseware]@row , VLOOKUP([Analysis Priority]@row , AnalysisPriorityTypeDropDown2:AnalysisPriorityTypeValue5, 2),…
-
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…