-
How to do a cumulative running count of a value in a column
I need to count the number of times a value occurs in a column and have it do a running count of it in another column. Example: I have a spreadsheet with a column (B) that will have numbers that will occur a varying number of times. In another column (A), I want it to count the number of times that a value shows up in…
-
Nested If statement
I am trying to populate a cell based on the State that they had choice from a dropdown column on the same sheet/row. I am tried many variations of the below formula and it is not working. Does anyone have any suggestions.
-
SUMIFS correction assistance
Currently, I'm using the formula below, but I need help adjusting this formula to add another criterion from an additional column into the formula. The additional column range I need to pull from is "Project type," and the criterion is "AE" to be added into the formula below. What is the formula to add a third criterion to…
-
Unable to use countifs
I want to count values in a column only if two of the columns are unchecked. For example in row 1 , Column "A" & "B" need to be unchecked to count value in column "C", row 1. I have tried multiple combinations but they don't seem to work or return an error. what would be the best solution for this?
-
Formula to Find Last Non-Empty Cell In a Row
I am using a sheet that tracks counts of different products by location, which gets updated in 30-minute intervals (product location by row and time intervals by column). My goal is to use a function to automatically pull the most recent count for each product, which would require the function to check for the last…
-
Trying to convert a form to smartsheet and having problems
Hello and Thank You in advance for any guidance you may be able to provide. I'm trying to convert a form that i use to track FTE changes into smartsheet. What I need to have is a section that allows for multiple responses for each type of FTE (Admin, Clinical, Educational or Research) some that might be the same (for…
-
Formula to Count Qty from an Order Sheet
Hi I have an order sheet that holds the quantity of an item being ordered. The sheet also shows whether there is enough of the item in stock or not. If the item is in stock I need to minus the qty from the corresponding item on the stock sheet. If the Item is not in stock, once the job is completed, it needs to add the qty…
-
Index Match function cuts off zeros
Hello all, I am pulling a cell value from a different grid with an Index Match function. The cell value is "89.09740". The value can be pulled succesfully, however, the number is displayed without the zero at the end: "89.0974". Is there anything I can add to the below formula that would make sure no zero is cut off at the…
-
IF(And/OR) Formula Help
Hello, I have the below formula I am working from and everything works EXCEPT the last part of the formula where we are asking for the health to show as blank if the start date is blank or the status is Not started. Also, we were using If(AND prior to using IF(OR and wondering what the true difference is. If we use "OR" is…
-
Filter by Parent Row with Children and Grandchildren
Hello! I recently created a sheet to track all of our projects (parent row) with some high level milestones (child row). I created a helper column so that I could filter just by the parent row of each project. In the helper column, I used this formula: =IF(COUNT(CHILDREN([Feature Request]@row)) <> 0, [Feature Request]@row,…