Countifs with two contains

Options

Why does my formula show #UNPARSEABLE?

=COUNTIFS({[Name] Initiative - RAID Log Status}, CONTAINS($[Column7]$120, @cell), {[Name] Initiative - RAID Log Action Owner}, CONTAINS(Input@row, @CELL))

$[Column7]$120 includes the word "open"

Input@row contains a name

Reference {[Name] Initiative - RAID Log Status} is a column with a dropdown

Reference {[Name] Initiative - RAID Log Action Owner} is a multiple choice dropdown

I like to count all open items for a particular person by:

  1. counting all items that are either "open (active)" or "open (blocked)"
    1. here I use "CONTAIN the word open from the cell $[Column7]$12
  2. and that contain the name displayed in "Input@row"

SYLVIA KAY | DIRECTOR PROJECT MANAGEMENT

PLATFORM ENGINEERING & TECHNOLOGY TEAM

AMERICAN EXPRESS GLOBAL BUSINESS TRAVEL

M: 404-664- 1025 | SYLVIA.KAY@AMEXGBT.COM

AMEXGLOBALBUSINESSTRAVEL.COM

follow us on twitter: @AmexGBT

follow us on instagram: @AmexGBT

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!