Smartsheet if cell contains text. I'd expect this to work, but I can't… May 10, 2023...
Smartsheet if cell contains text. I'd expect this to work, but I can't… May 10, 2023 · Said another way, I want to type a string into a cell (A1), look at the description column on another sheet, then return a list in column B of reference numbers that are adjacent to the cells that contain the string from A1. 68K subscribers Subscribe This formula works to count the presence of _SP_ in a string present in column (range one of the NGS loading sheet). Thus, I could use CONTAINS or HAS to get the function to perform as intended. " Jan 18, 2022 · The Flavour@row cells are basically like a one-to-many - in the CONTAINS function, they'd be more like where you're looking for the text, but there are multiple options that I'm trying to look for. the value 7621 in a column that has '7621-Sewing machine'. I was using the =IF (CONTAINS ("a", [Use Cases]@row), "Use Case") formula. g. 1-12) on the same row. CONTAINS Function Is used within another function to search for a character or string. From the PM sheet, I want to search through the entire "Status" column in the PP sheet to see if any cell contains "On Hold". wiwmofi fgrjka svlowbz tujvo ktcicj yusg cbv ughgxl tvbd blobjb
