I have a column of people smart chips in a spreadsheet, and I want to use them in the range of a SUMIF, but I can’t get them to match any value I provide as the criterion. I’ve tried the string value of the chip (e.g. "John Doe"), and I’ve tried the corresponding email address (e.g. "[email protected]"), but I can’t get anything to match the smart chip. The only thing that has worked is referencing a cell that contains a smart chip. How can I match a smart chip for the purposes of functions like EQ, COUNTIF, and SUMIF?