-
Converting International Dates to Standard
I am looking for a formula/function that can take an international date dd/mm/yyyy and convert it to mm/dd/yyyy. Seems like there should be a convenient function that can do this?
-
Cross-sheet Copy and then INDEX/MATCH Help Needed
I am working on developing an End to End Testers sheet and a Defect Sheet. When a scenario test has resulted in a Defect Confirmed, I would like the Scenario ID, Scenario Name, and the Scenario Description to be pulled into the Defect Sheet. My initial approach is to break this information into 2 cross-sheet formulas.…
-
NETWORKDAYS & Weekends with Notifications
I am using the below formula to try to stop notifications on weekends and holidays. My automation has a condition to check if this field has a check mark. If it does have a checkmark, it sends a notification. If it is unchecked it is supposed to not send notification but it appears to still be sending them on the weekends.…
-
Question about automation to generate duration of each status
Can we get an automation to generate how long is the duration of the open, closed, and average days that each open status have been open for before a status changed? Also can we get an automated count of days that the item has been open or until the status changed to closed?
-
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 |…