-
COUNTIFS Using And as well as Or
Hello everyone, I am looking to have an information sheet that is looking for several criteria with "and" and "or". For example, I want the formula to count if the other sheet has "Priority 1" and "John Doe" and a status of either 1 or 2 or 3. I will have another cell on the information sheet for "Priority 2" and "John…
-
Challenges with Summary Data Formulas/Dashboard Sometimes working
I have a first sheet that was filled out by people using a smartsheet form to populate a sheet for a certification program. A second program is only open to the people who were already certified in the first program, so they fill out a Smartsheet form with minimal fields, include a unique ID number, and the rest of their…
-
Parent/Children Formula
I am trying to have a formula look at a "Parent" row Status IF it is blank than to then look at the child row associated and if the Status is Red, Green or Blue, place status within Parent Status ONLY, if it is not any of the listed status leave blank. I have the below formula, but it keeps throwing a #circular ref error.…
-
Formula to show certain selections of a drop down selection.
I have a sheet with a drop down list (Countries ) and the user will select countries across the world. And I want SS to return only the selections that met criteria. In the image, the user would select items in the country column and the formula would return items from the Europe Countries Column. I feel like this should…
-
Get data from sheet that contains a multible select drop down
I have sheet 1 (S1), where I have a multible drop-down list with model-numbers + a Supplier 1-column. Here I have the data I need in Sheet 2 (S2). In sheet 2 I have a row with model numbers, WHEN these matches with model-numbers in S1, I need the supplier-name in the row from S1 to go into the supplier-column in S2. This…
-
Collect a contact list from another sheet
Hi Guys Just a quick one, I have a contact list see pic 1 below….. I want a Formula that collects all the Responsible person (Contact) and pastes them all in one cell on another sheet - Recon Monthly Intake sheet, (see pic 2) I want the collected list to appear in a cell on a Column named recon preparer (see pic 2) Can you…
-
How to use SQRT function?
Hi! I searched through the functions and see that there's no SQRT function in smart sheets and the cells don't allow you to use the ^ key. Has anyone had experience, or have any advice on what to do? I tried making a whole new column just to root the function and it returns #unparseable, along with this the (A1)^0.5…
-
Sumifs or Countifs
Trying to figure out the formula to solve for the following: If Column A = "Bob" or "Frank" , and if Column B = "Blue" , then count Column C's #. Basically trying to figure out how many blues Bob and Frank have based on the Qty in Column C. I need to exclude everything that doesn't meet those requirements. Example: Column…
-
Adding IF condition Formula
Good morning, I'm struggling with the syntax for the following formula where I'm trying to include a WHERE condition that looks for an active status. The formula works great until I introduce the WHERE condition to the point I've just thrown my hands up. My status flag condition is either 'Active' or 'Not Active', or…
-
Include a form field with no option to fill in info?
Hi all, Is it possible to include a field in a form with no option for the user to fill in? For example, if someone selects something, I just want to give them an instruction, not have them provide any information. Here is the specific scenario: Is this budgeted for? Yes/No If No, then display text: Please confirm a budget…
