#INVALID DATA TYPE

CJ Christie

CJ Christie ✭✭✭

09/18/24 in Smartsheet Basics

I am trying to set a rule to change the color of the font to white when #INVALID DATA TYPE populates a cell. I have tried "contains" and "is not a number" but its not working.

Any suggestions?

0 ·

Answers

NicoLHC ✭✭✭✭✭

09/18/24

@CJ Christie do you work with conditional format?

If my comment helps you, I appreciate a 💡
Kind regards
Meet me at Engage in Seattle!
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
🎥 YouTube 🚀TimeLine View
http://lighthouseconsultings.de/
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Fairly new to Smartsheets - Having trouble with a countifs / date formula. Need your help!
I have a "master data" sheet that has a "DATE OF INCIDENT" field column, and a "FOUND ON A SCHEDULED INSPECTION" field column that populated as either yes or no. These are the two references I'll want to use in my formula on my metrics sheet. In my metrics sheet I want to use a COUNTIFS statement to tell me how many passed…
A workflow has become invalid
Hi, I received an email saying that one of the workflows of a particular sheet has been deactivated. The action for this workflow is so simple, so when the column in another sheet is changed as "completed" the row is copied and moved to a master sheet. It is important to mention that we have been using this for months and…
Permissions Workspace vs Sheet
I want to set a Workspace permission for all members (except Owner and 1 Admin) to Editor - Can Share, which I'm able to do. Within that workspace are some files that I want some of the members to have Admin permission, but still only have Editor permission for the other files in the Workspace. When I open the sheet for…

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