-
COUNTIFS with Cross-sheet references
I'm trying to get a count of rows between two dates AND where we have the status as one of three choices. I've tried using the OR logic embedded in the COUNTIFS formula, but I couldn't get that working. Instead, I created a helper column next to status called 'Concluded' to evaluate whether or not the ticket's current…
-
Need help with a IF(OR) formula
I have the "base" formula correct and working but can't figure out how to string it together (are there best practices in this area?) with a larger formula: This piece works: =IF(OR([Go Live Month]@row = "January", [Go Live Month]@row = "February", [Go Live Month]@row = "March"), "Q120") I want to add conditions for the…
-
SUMIFS with multiple criteria in multiple columns
Hi - I'm trying to create a formula that will sum the amount of hours in one column when it meets a certain criteria (type of hours) from another column, but only if they were accrued after a certain date (a third column). No matter what I try I either get an error. Here is the formula I have so far (which is wrong -…
-
Health RGY Formula
Hello All, Our team has created the below formula which worked UNTIL we added the bolded part below. We cannot figure out what is missing and we keep getting an #Incorrect Argument Set error when we change the End Date to be anywhere between that 10 & 30 day range. =IF(AND(Status@row = "In Progress", [End Date]@row -…
-
auto incremental's from form data
I am trying to make a column auto fill down based on the number in a column. So if column [# of Registers] shows 5. i would like the Register Hostname to populate out from USRETAMXT01 - Reg05 down the column.
-
Conditional Formatting Not Working with Formula: change colour based on date
Hello everyone, I'm trying to conditionally change the background color of a date column based on if it is today or yesterday. It works just fine if I type in a date, but if the date is populated via formula then it doesn't work. I have tried disabling and re-enabling with no luck. The cell in question references 2 other…
-
Template and use of formulas
I am using a project plan template and have some formulas on the Health prebuilt - however if someonee adds another task via insert (which they should be able to do) it does not carry/maintain the formula on the newly added Health column. Please advise.
-
Alert Someone on every day a Task is marked as happening
Hello, Can I create an Alert (Alert Someone) that would send a notification to an email for each day when a task is listed as happening in relation to the Start and Finish dates, inputted in the system? The logic cannot be static, and should be based on when a task Starts and when it is listed as Finished. Dates can vary.…
-
Parent/Child Formula
I need to create a formula where the parent row determines what it displays in its cell based on the following criteria from the children: If any child cell below it is blank, skip it If there is a name in any child cell, add it to the parent cell If it is a duplicate name in any child cell, skip and do not add to the…
-
Count Multiple Criteria
I'm trying to count a number of different items with multiple criteria. This is how I currently have it : =SUM(COUNTIF(Department:Department, "03 AACA Finance") + (COUNTIF(Department:Department, "03 AANJ Finance e"))) Is there an easier way since SS doesn't do arrays or do I need to keep adding the COUNTIF to the formula…
