-
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.…
-
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…
-
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…
-
COUNTSIFS does not Contain
Hello, I've put together the following formula, to count certain items in a different sheet that don't meet certain criteria, please see below. =COUNTIFS({SE-Region}, Region@row, {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Summary}, <>CONTAINS("Onboarding", {Summary})) The formula works until…
-
Creating WBS formula for deliverables spread out over phases
I have a project schedule that is organized by phases. Tasks for each deliverable are spread throughout the phases. The team has requested we add a WBS ID to the project schedule so we can identify/track the work across the phases. I'm trying to create a formula to generate the WBS. My formula to create the WBS Phase - 0…
-
Count the number of times a person's name appears in an "Assigned To" column
I currently use the below formula to count the number of times a name appears in the "Assigned To" column. The issue is that this column can have multiple names in the same cell, so I have to created a separate formula for every possible name combination. Is there a way to have a formula that looks for a name string and…
-
Formula to calculate amount of days/weeks/months between two dates?
I work in managing long term, in vivo research studies so keeping track of age is important, I am assuming this is a pretty basic formula but I cannot seem to figure it out. I also want an automatic column that just gives me current age. Please help!
