nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Countif range from multi select contains (value) under each parent from another sheet

Julie Castell

I need a cross reference formula using countif a specific value in a multi select column is under a parent from another sheet.

Find more posts tagged with

Formulas

Comments

Paul Newcome

You cannot reference hierarchies directly with cross-sheet references. You would need to calculate those values on the source sheet, then pull them to your target sheet.

Sign in to join the conversation!

Quick Links

Trending discussions

HOW TO USE IF BLANK WITH THIS FORMULA
I am using this formula to return the month and year from a reference date, but cannot figure out how to use IFBLANK with it in order to return a blank cell if the reference date cell is empty. This is the formula I am using and trying to add IFBLANK to. =IF(MONTH([WALL DESIGN FINISH (ACTUAL)]@row) = 1, "01-",…
Need help with a formula to determine if all responses have been received for each group in the Smartsheet
Hi! Thanks in advance for taking a look! I have a Smartsheet that has a line for each person being reviewed as well as their "client number". I created a helper row to let me know when each person has completed their actions, but I'm having a hard time finding a way to indicate when everyone for that client number has…
COUNTIF Cells within a range are NOT BLANK
Hello, need help with a formula - I need to count within a cell range how many are NOT BLANK, this is the formula I currently have that is not working - what needs to be changed? /COUNTIF(Charter@row:[Retrospective/Lessons Learned]@row, <>"")