-
Categorize If Project Completed On Time
Hi - I have most of the formula working below except for when a project is not completed yet and the Actual End Date is not inputted, and Helper (Difference in Days) is not calculated. When the Helper (Difference in Days) is blank, I wanted to Helper (Completed) column to pull "in progress" Below is current formula with…
-
SUMIFS help!
Hello! I've attached a screenshot of what I'm trying to do. Basically, I want to do a SUM formula on the range int eh screenshot IF the left column is "Supplemental" and the top row is Monday-Friday. I thought the way I had set it up was right, but I'm getting INCORRECT ARGUMENT SET. Any help would be appreciated! Thank…
-
formulas with percentage
I pulled in a number from another sheet, % Complete from Plan, that is a percent and want to subtract this from 100%. This is the formula I am using: But it renders #UNPARSEABLE
-
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…