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

Is it Possible to Have a Form Pull From a Summary Field on the Sheet?
I believe I've seen that this isn't possible but wanted to check if anything has changed or if someone came up with a solution. I have a form where people sign up for a tour. In the main sheet I use the Sheet Summary to keep track of how many spots are left for the tour. I would like to pull from this Sheet Summary field…
Missing Reports on a Dashboard. Then suddenly appears after refreshing. Then missing again.
Hi everyone, Have you experienced being haunted by a Report widget within the dashboard? Our Clients were complaining that some tables within the dashboard suddenly went missing, but after refreshing, it will appear and then gone again. This is my first time encountering this, and I've already raised a ticket to Tech…
Dashboard Issues & Privacy
I have a master data sheet with data on it for 5 different clients. I've then created a series of reports that filter information for each client so they can view their own data without seeing everyone else's data. But I can't give them access to a report without giving them access to the source sheet. So I created a…

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