IF(OR) Statement
Trying to have a fornula recognize between a text and a number. In the example below I want to have the Job# Join several items together to build the job # and i need 00- to be added to each row as a new job is started. In doing this, the formula =IF(ISNUMBER([Neighborhood Code]@row), "00-", "") is working fine as long as its a number. Cant figure out how to make it work if its not a number. Example - 5A. Any thoughts?
Answers
-
In the 00- Column just add ="00-" then you can do this in the job # column:
=[00-]@row + [Neighborhood Code@row] + [4th Column]@row
Sincerely,
Jacob Stey
-
I tried this so far and cant make it work.
=IF(ISNUMBER([Neighborhood Code]@row), “00-“, “”, ISTEXT([00-]@row), “00-“, “”))
-
Try the functions ISNUMBER and ISBLANK to modify this formula
It will help to manage numbers and text effectively
Huma
Community Leader
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives