-
Is it possible to match multiple values with in a single cell?
I'm sorry if this is long winded. I am creating a workflow process where a file will need to be emailed to multiple users at different locations. There is a drop down that lists the locations, in this example it's 3 separate locations, Portland, Minnesota, and Houston. I'd like to keep this drop down to allow multiple…
-
SUMIFS with an either or condition
I'm struggling to make this work . . . . I'm starting with a SUMIFS that works: =SUMIFS({5_METRICS_SALES LEADS Current Year Goal}, {5_METRICS_SALES LEADS Today}, YEAR(@cell) = YEAR(Today@row), {5_METRICS_SALES LEADS Sales Lead}, VARIABLE@row) The 5_METRICS_SALES LEADS has two columns I want to sum (Current Year Goal and…
-
Check Box If "Due Date" is in the Past and Keep Box Unchecked If Not
Hello, I am wanting to use a simple formula that will check a box if the "due date" column is in the past while also keeping it uncheck if the date has not past. I am assuming I will use the IF formula, but not sure how to write this. Thank you, Ryan Holguin
-
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.