Satisfy all requirements; with different formats of columns
Hello
I need some help i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox complete ..
initially i think i need to use a countifs formula to tally all columns but only if they meet certain criteria . a few of these columns are checkboxes, while others are dropdowns.
if all are satisfied then i would set up a formula to check the checkbox .. from then send off a notification with access to attachment .. (i am good with this part)
my problem is the countifs formula part .. i can get two criteria to work; but as soon as i try to use additional criteria within the same column it does not work .. for example:
=COUNTIFS([Analyst Check]2:Analyst Check]2, =1, [Numbers Recorded]2:[Numbers Recorded]2, <>"")
I was hoping to use the not blank .. but that does not seem to be working .. the numbers recorded column has 4 choices .. two of which would satisfy the criteria ..
sorry if this is confusing also:)
thanks for any and all help!
Comments
-
this one ends up as invalid argument ..
=COUNTIFS(Analyst Check]2:[Analyst Check]2, =1, [Numbers Recorded]2:[Numbers Recorded]2, <>"", <>"Not yet")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!