I have this formula and it works well however I need the final result need to be a number. When I in
I have this formula and it works well however I need the final result to be a number. It needs to be a number because the index match does not work when I am comparing this value. I tried to add value in front of the formula and it gives me invalid value. I prefer not to to add another column to resolve this problem.
=IF(CONTAINS("/", [ORIGINAL STUDY NO.]@row), RIGHT([ORIGINAL STUDY NO.]@row, LEN([ORIGINAL STUDY NO.]@row) - FIND("/", [ORIGINAL STUDY NO.]@row)), IF(CONTAINS("/", [STUDY NUMBER]@row), RIGHT([STUDY NUMBER]@row, LEN([STUDY NUMBER]@row) - FIND("/", [STUDY NUMBER]@row)), ""))
Best Answer
-
Hello,
Try: =IF(CONTAINS("/", [ORIGINAL STUDY NO.]@row), VALUE(RIGHT([ORIGINAL STUDY NO.]@row, LEN([ORIGINAL STUDY NO.]@row) - FIND("/", [ORIGINAL STUDY NO.]@row))), IF(CONTAINS("/", [STUDY NUMBER]@row), VALUE(RIGHT([STUDY NUMBER]@row, LEN([STUDY NUMBER]@row) - FIND("/", [STUDY NUMBER]@row))), ""))
Hope this helps!
Best,
Zach Hall
Training Delivery Manager / Charter Communications
Answers
-
Hello,
Try: =IF(CONTAINS("/", [ORIGINAL STUDY NO.]@row), VALUE(RIGHT([ORIGINAL STUDY NO.]@row, LEN([ORIGINAL STUDY NO.]@row) - FIND("/", [ORIGINAL STUDY NO.]@row))), IF(CONTAINS("/", [STUDY NUMBER]@row), VALUE(RIGHT([STUDY NUMBER]@row, LEN([STUDY NUMBER]@row) - FIND("/", [STUDY NUMBER]@row))), ""))
Hope this helps!
Best,
Zach Hall
Training Delivery Manager / Charter Communications
-
Thanks for you help. It works
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!