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

European Date Format - Only working visually?
Hi, I have two columns in my sheet that are set as dates, though many of them are formulas that derive in dates based on variables such as, [If date 1 = X and task 1 takes 3 days, DATE = Date 1 + task duration = X+3] and so on. I have the date columns formatted in Day/Month/Year: however it only seems to impact the…
Alerting the person that submitted the form
When multiple individuals within the company will be submitting a form for approval, how can I have the submitter to be notified if something was approved or declined? There are two approval stages but I need the submitter to be aware of the final stage.
How to copy form to create its new a bit different version
Dear All, I created a form in Smartsheet that is quite complex and I would like to create similar version of the same form but with some additional options to see what version will be better for my needs. As I don't want to start from scratch with this new version of the form, is it possible to copy ma first form and just…

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