Conditional Formatting

NSAN

NSAN ✭

12/05/19 edited 12/09/19 in Smartsheet Basics

I am trying to setup conditional formatting for a cell if it does NOT contain certain text. There is an option for contains, but not the other way around.

Ideas for a solution or go around?

Thanks!

Tags:

Conditional Formatting

0 ·

Comments

Bladerunner ✭✭

12/05/19

Will "is not equal to" not work?

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again

Help shape the future of Smartsheet.
Share your ideas and feature requests.