-
Need help combining IF, AND/OR formulas
Hey yall! I am trying to write a formula that will read the 'Check In' column and "Last Wk Check In' column and check the '2 Wk - No Check In' flag if the following cases occur: If both columns read 'No Check In' (that flag is currently working as can be seen in the screenshot below) If the columns both read "No Data', I…
-
Whats the most reliable way to automate data collection by student/client name?
I'm pretty new to Smartsheet and I have a pretty big set of data for each one of my 60-80 students I am trying to use it to track. I manage a therapy department at a special ed school. I have two sheets one that gets raw data from a form filled out by multiple therapists for between 60-80 different students and another…
-
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…