-
Allow editing for cells in a formula column
Hello, I have found that when a column is a formula column, you can no longer manually update those cells--ever. Is there a reason these cells need to be "locked down"? When you add a formula, just to the cells manually, and not the entire column, you can always update it whenever you need to. I know I can "turn off" the…
-
Can I share a folder within a workspace to someone without having to share the whole workspace?
Is there a way to share one folder within a workspace with someone, without sharing the whole workspace with them? I want them to see their folder, but not everyone else's folders within the workspace. Is this possible?
-
Sharing a folder in a workspace
We created a workspace called "Active Projects" to share with the full company and are wanting to share specific folders in that workspace with customer project team as "commenters". I found it seems I can only share at the workspace level. Is there a better way to manage this so that I can share all folders with the…
-
Automated Timestamp Capture for Status Changes
I would like to propose a function or automation that captures a timestamp specifically when changes occur in a designated column. For example, if the Status column changes from Pending to Completed, the system should automatically record the exact date and time of that change. The challenge with relying on the standard…
-
Keeping Parent Rows Collapse
I wanted to ask a quick question that I’ve been struggling to figure out on my own — and I know there are a lot of helpful people here who might have ideas. I receive a few Excel sheets each week via scheduled email exports. The issue I’m running into is that I’d like the parent rows to always be collapsed by default when…
-
Best formula to link data in another cell
Hi all, I wanted to know what the easiest way would be to link data from one sheet to another. I have working cross-reference formulas, cell-link, and even just using miscellaneous formulas to reference them, just as proof of concept. I was wondering, what is the difference between using Index-Match to pull in data, versus…
-
Increase cell character count
I use Smartsheet to document contract compliance. Sometimes compliance actions can take up to 2 years and I exceed the 4,000 characters in an excel cell. Is there a way to increase the # of characters in a cell?
-
I need to talk to smartsheet about my business account
Business account up for renewal. I need to speak with smartsheet customer service about seat types and true-ups and I'm getting nowhere with articles. Sales rep is out and we are on deadline.
-
In proofs, provide option to send direct links to a specific PDF page
Hi, using proofs for contract generation and approval could be great. Sometimes contracts are very long and have multiple parties involved, so the amount of annotations is large. It would be very helpful to be able to send a person a link to a specific pdf page (like the official #pagenum technique from Adobe), so she/he…
-
Conditional Formatting Blanks
In Conditional Formatting, when Setting a Condition, it would be helpful to be able to select "blank" as an option instead, especially when applying a format when conditions are not met. Some conditions are easier to do in the negative (especially when options are constantly being added), but without being able to select…