-
Dynamic numbering of feature list
I have a feature list that has a number associated with each of them (by row). I'd like to be able to reorder the list as I get input on their priority and have the number associated with it dynamically update. For example, if #5 moves ahead of #3, I'd like #5 to be #3 and the others below to reorder too.
-
If Status is one of two options, then checkbox is selected formula
I am trying to build a formula where if a status is either "Pending-Crim" or "Clear w/ Exceptions" then the checkbox will check, however I can't seem to get the formula to check the box once the status has been updated. Here is the formula I am using: =IF(COUNTIFS(Status:Status, "Clear w/ Exception", Status:Status,…
-
if and blank
Hi, I have a date that a survey was completed and a date that someone has contacted a customer and I'm looking to create a formula that highlights if the response date was over 3 days ago AND there has not been a successful call (the contact date column will be blank) then mark this as red, if the response data was over 3…
-
Nested IF statements
Can anyone assist me in where I am going wrong? =IF([GEAR.]@row = true, [C/N SQD]@row, IF(LTG@row = true, [C/N LIGHTING]@row), IF(AND([GEAR.]@row = true, LTG@row = true) = true, [PROJECT TOTAL]@row)) If checkbox1 = true, set value to cell 1, if checkbox2 = true, set value to cell2, if BOTH checkboxes = true, set value to…
-
SUMIFS with Multiple Criteria
I have worked up SUMIFS that sums the Final COS for each of main Account Managers individually and for multiple codes in a contracted column that equate to a loss (this worked out fine): =SUMIFS([Final COS]:[Final COS], [Account Manager]:[Account Manager], "Doe", Contracted:Contracted, "not won") + SUMIFS([Final…
-
Formula Help
Not the greatest at creating formulas so I am looking for some assistance on this one. =IF(CONTAINS("0", [Product Categories selected]@row:[Keyword field filled]@row), "Complete", "Incomplete") Here is what I am looking to do: If the four columns are all "O" then mark the status of Incomplete but if all four columns are…
-
Sumif/Sumifs question
I have a sheet that lists the number of awards that have been issued since the inception of the program. I want to create a report that breaks it out by year, award level (there are 3 different levels), and sum the total of that level. I have it by year, but adding the level I have not been able to figure out. Can someone…
-
Is it possible to Sum based off of status change in a different column?
For instance, if I had two columns, one is a number value and the other is a status value. if the status value is red and i wanted to sum just the values of the red statuses, is this possible by using a SUMIF Function. Thanks, Brendan
-
Functionality of dashboard with Forms on it
Hi, Created 3 forms for doing employee reviews with underlying grid sheets. 1 form is an Employee Self Review, 1 Form Employee Selection, and 1 Form Reviewer Form. Idea is a employee fills out self review, then sits with manager. Manager opens dashboard, selects Employee from Employee Selection Form, then clicks submit.…
-
How to convert my formulas to a column formula
How do I convert these formulas to a column formula? So the formulas work perfectly; however, I find myself constantly updating the source sheet when someone inserts or enters new records and then I have to go to my metrics sheet to make sure they are applied. I'm doing way too much manually work with these sheets and I…