Welcome!

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

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

Query: Extract Day (Thu) from Date Column
Hi, this column is a date column. I need to extract the day (like Thu) from it for each row. Could you please suggest a formula?
Automation Change Cell Value not working, but working when Test run
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
Formula to Display Weekday Horizontally
Hi, I have a sheet where i am trying to pull the weekday horizontally based on the dates.But I am unable to fix the formula.Can anyone suggest what formula to use