-
Days Since Tickets Were Created
Hello, I need some help with this formula, I am trying to create a datasheet that can pull in tickets from another grid & tell me how many tickets were opened within these timeframes. 30 days ago, 31 - 90 days ago, 91 - 180 days ago over 181 days ago. I've done similar formulas with this for finding things between dates,…
-
COUNTIF Formula
I am trying to create a countif formula to give me a count at the top of my column of how many empty rows in a shelf I have. If certain spaces in the shelf are empty they are labeled in my column as "EMPTY". I have tried this formula: =COUNTIF([Study Number]1:[Study Number]636, = "empty") but am having no luck. Please help!
-
Hlookup Help
Hey, I have a formula currently in a spreadsheet that is an Hlookup, and I am super stuck recreating it in SmartSheet. I have tried the index match, but it is still not working. I have it attached but basically, I have 2 factors "likelihood" and "impact" that drive the "severity". There is a table that says what the…
-
Nested IF Formulas
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.
-
Can you INDEX and MATCH a date
Can you INDEX and MATCH a date from one sheet and return the value in another sheet? Seems like date format not compatible with INDEX. The formulas that I have tried are; =INDEX({1509LV_Schedule Range 1}, Description@row, MATCH({1509LV_Schedule Range 2})) =INDEX({1509LV_Schedule Range 1}, Description@row, {1509LV_Schedule…
-
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…
