Is there a way to clean up a formula with carriage returns or hard returns?
I'm trying to clean up a large nested "IF" formula so it is easier to understand. In Excel I can use ALT+ENTER to carriage return the text so it's easy to read. Basic formula protocol. I can't find anything in smartsheet forums stating how to do it, so I'm assuming it's either incredibly easy or doesn't exist. Currently it is a giant run on sentence and a pain to navigate.
Fingers crossed.
Todd
Answers
-
Hi Todd, I'm not aware of any way to do that within a formula. I copy complex formulas into Word and break them into pieces.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
This isn't exactly what you are looking for, but there is a way to put a carriage return in a formula. You can use CHAR(10). You need to have word wrap turned on for the column for this to work.
You can take the = off the beginning of your formula, enclose it in double quotes and then insert carriage returns.
Example
="Hello" + CHAR(10) + "World!"
Hello World!
-
+ CHAR(10) + worked perfectly!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!