Archived 2017 Posts
Archived 2017 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Is there an formula edit window?
Is there a formula window available so I can edit/create long formulas better? The one the pops up when you start typing in a formula overlays other cells and makes it difficult to select columns int he same row. I'd like to have a separate popup that I can move around on the scree or make bigger so I can see and work on a complex, or long, formula easier.
Thanks
Comments
-
I use Notepad, copy and paste in between. You can even space out formulas by putting them on new lines with enter key and it will autofix when pasting back into smartsheet.
-
I agree with Luke_TK -- I do all my lengthy or nested formulas in notepad++, which also provides highlighting of the parenthesis which helps me to make sure I have closed them all correctly.
-
Yeah, what Luke_TK and Mike said.
I use UltraEdit.
I also build complicated formulas using multiple columns first and then combine them once each part is tested.
Craig
-
I would be incredibly helpful when auditing formulas if the formula edit window did not cover the cells being referenced in a particular row. Even more frustrating, when you scroll up and down, the formula edit window moves with the referenced row.
Notepad works well when creating formulas, but not for editing.
David
-
Hi David,
I agree.
Please submit an Enhancement Request when you have a moment.
Have a fantastic day & Happy Holidays!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Done, thanks and Happy Holidays to you as well!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 206 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives