-
COUNTIFS one OR another criteria
Hello, I am trying to find the number of cells in a column that are blank OR do not contain a specific word. I believe the way that I have it right now would be AND rather than OR. Any suggestions? Need: If Accounting column is checked and Bio Status is blank OR does not contain "Posted" I'm currently getting 1 as the…
-
Unable to delete content of a column
Hi, Has there been a feature change? I used to be able to click on the column header and hit delete and the contents would be deleted leaving the column blank Now when i do it it only deletes the top cell? Any help or comments would be appreciated Thanks Dave
-
SUMIFS with Multi-Select Criteria
Trying to correct my SUMIFS formula include two criteria from a multi-select column. I'm currently getting UNPARSABLE every time try OR, AND, or HAS. Here's what I have so far with my current criteria, I just need to add an additional option for "CXL - COVID19" in addition to "Approved": =SUMIFS({FY Amount}, {FY}, FY 20 ,…
-
Help w/adding up formula totals
Hi team - I created a test sheet that I'm experimenting with various drop down menus creating scores. The drop down to score is working fine, where I have a problem is getting the "Total score" column to add all 5 scores. What am I missing? Total score formula: =VALUE([Impact score]@row + VALUE([SLO score]@row +…
-
Help w/nested IF statements with numbers that are between certain criteria
Hi team - I'm trying to create a nested IF statement that shows the following in the Status column: Green status is Total score 450 or above Yellow status is Total score between 449-350 Red status is Total score between 349-1 Gray status is Total score of 0 The Total score column is a formula that sums up specific columns…
-
Cell linking and updating a column
I have a master sheet that contains a column called "Product Family." This master sheet is updated weekly, and some of the Product Family rows change - added or deleted. The cells in the Product Family column on the master sheet are linked to another worksheet (called "Curation Audit") - also in a "Product Family" column.…
-
Calculating costs for a task over more than one month
I'm trying to come up with a formula to calculate the labor costs per month in one sheet ( 12 columns, one for each month), by referencing another sheet, and referring to the start/finish columns of said task. E.g. Task 1: Start = Aug 27, Finish = Sept 5. So in my cost sheet, the formula needs to refer to the start date…
-
Using IFS statement with date and check box
The simple statement is I want to have a sum of work hours in a department, that is still incomplete, during a calendar period. Currently the formula is: =SUMIFS([Work Hours]:[Work Hours], Department:Department, "Wire", Finish:Finish, >=DATE(2020, 9, 1), Finish:Finish, <=DATE(2020, 9, 30)) * 8 A suggested version has been…
-
Same formula on two different sheets one works the other does not
I copied a working formula from one sheet to another sheet and changed a column setting. I cannot figure out why the column name in the formula doesn't "active". Any ideas what is wrong?
-
Why does this return invalid data type? Any suggestions?
I'm trying to get a rolling 30 day issue count to return the 5th top number so I can give a list of clients that have the top 5 highest volumes of issues in the last 30 days. =IF([Rolling 30]:[Rolling 30], 1, LARGE([Issue Count]:[Issue Count], 5)) My Rolling 30 column is a checkbox with a formula in it. =IF(TODAY(-30) <…
