For the CONTAINS Function??

Sarah Dunsford

Sarah Dunsford ✭✭

11/02/23 in Formulas and Functions

What do you do when a text in a cell that contains the text string you are looking for is shrouded with parenthesis?

0 ·

Answers

Paul Newcome Community Champion

11/02/23

Are you able to provide a screenshot for context?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter
Sarah Dunsford ✭✭

11/02/23

Thanks but figured it out ... user error :)

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Formula is #unparseable and not cleat why, help?
=IFERROR(AVG(COLLECT({Score BA}, {Employee Email BA}, $Variable@row, {Date of Review BA}, ISDATE(@cell), {Date of Review BA}, YEAR(@cell) = $[Last Year]$102, {Date of Review BA}, MONTH(@cell) = [Last Year Feb]102), COLLECT({Archive Score}, {Archive Employee email}, $Variable@row, {Archive date of review}, ISDATE(@cell),…
How to use index collect?
Hi, I'm trying to write a formula that will look at a particular column (in this case the "extrusion" column) and return the first entry that has a check in the "cycle count is due column". My current formula is below and comes up unparseable. =INDEX(COLLECT({Metal- Shop Floor Inventory Range 1}, {Metal- Shop Floor…
Help with Countifs and not contains formula - no longer working
I have been calculating how many submissions in a month in one column (column A), and cross-referencing against another (column B), to ensure I'm not counting items that have a particular word in column B. I used the AI help (when it was available) and the following was working: =COUNTIFS([Date Received]:[Date Received],…