What formula would I use count a multi select option with a certain condition? For example in this data set, I want to count the number of times IP1 occurs in Phase 1b:
Hi @Heaven Casher,
Try this formula:
=COUNTIFS(Groups:Groups, HAS(@cell, "IP1"), Phase:Phase, "Phase 1b")
Note, you'll need to modify the formula to fit the name of your columns. In the formula above, I've named the column which contains your multi-select values as "Groups", and the column which contains the different phases as "Phase".
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have a list of action items that can be assigned to several departments by using a multiple drop down list with dept. names in the assigned column I am trying to create a summary sheet to count the number assigned I have tried both Contains & HAS But my answer is 0 - Just using the count if gets me 23 and there are 2…
I am hoping someone might be able to guide me. I am trying to count how many of certain courses people are interested in. All options populate into the same column. Is there a way to do something like: =COUNTIF(Which courses are you interested in?, Project Management)
Hello! I have not written formulas in quite some time, and need some help. I want to check the "Most Recent" box, if it is the most recent submission for that workstream.
©2024. All Rights Reserved Smartsheet Inc.