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.
Hiding Formulas
Comments
-
There is no way to hide the tooltip.
Some of your clients will be Admin's of the sheets and whatever you could hide, they will be able to unhide.
This isn't like an MS Office VBA solution where the code is behind the scenes.
If you really need to do that, try the API. You can provide a binary or web-solution where everything is done 'magically'.
Or make sure your terms and conditions (T&C's) protect your intellectual property (IP)
Most consultants, I believe, struggle with this.
I can do a really complicated formula in about 15 minutes.
It looks easy when I am done, but it took a long time to get to the point where formulas (or whatever skill you have) are second nature.
There's the story of the man brings a car to a shop because of a noise and rough engine idle. The mechanic says it will be $750 to fix. The man says OK. The mechanic takes a small hammer and taps lightly on the rear tail-light. The car runs great.
The man says "$750 for two taps of a hammer?"
The mechanic replies - $5 for the tapping. $745 for knowing where to use it.
Craig
-
What i would suggest is the following:
Say column 3 is where the magic formula is, keep the formula in there, in column 4 put a formula that is (=column3) then hide column 3.
This way all they can see is the result.
You just need to make sure that they are set to editor so that they cant edit column layout
-
If you can get away with having them as only Editors, that works.
Most of my solutions are turned-over at the end - and that only delays the problem.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives