-
Prevent Sorting on Shared Sheet
We have a lot of users using Smartsheet as a tracker. Team members sort and then filter to get the information they need. The problem is that the sort affects all of the other users who are sorting on different things. Is there a way to have the sort only apply to the user that is sorting? Similar to the way that filters…
-
Remove cell contacts, already removed from contact list, and sharing list, and culumn properties.
Hello, I've noticed that contact columns save, or cache, the contacts that have been previously entered in that column. If I begin typing a name, it will produce a drop-down menu that includes all of the contacts which have previously been used in that column and which also begin with the letters I've entered. For example;…
-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
-
Sheet Row Limit - Automation Recos / Suggestions
With one of our clients, we are running into the 20,000 sheet row limit, and I was wondering what others have done to work around this issue? My first instinct is to createduplicate a sheets, and then use a report to pull it altogether in the end. It's a pretty manual solution, so I'm looking for something more automated…
-
Is there a function that counts a cell if it contains a value rather than equals that value?
Is there a function that counts a cell if it contains a value rather than equals that value if you have cells with "dog", "cat", "cat dog" and you want to count "dog" using excel you can use this formula =COUNTIF(A1:A3,"*dog*") but the * doesn't seem to work in smartsheet
-
Parent Child Numbering
With A LOT of help from the community I was able put this together but, I think there must be a better way. The last column is what I am trying to get to. Auto-generated Sequential number in this format T-00001 when Ancestors = 0 Auto-Generated Sequential number in this format T-00001.1, T-00001.2 (where T-00001 is the…
-
Lock a shared sheet into a standard format/setup
It would be great to eliminate the frustration of your view on a shared sheet being rearranged by cell width and wrapped text done by another user. Individual users should have the ability to save their own view of the sheet, or clear all their customizations and have it revert back to the original default view. Could work…
-
Filters, multiple users - do the filters stay seperate?
I have a large release plan and our users would benefit from using filters to pull out information specific to their department or the product they are assigned. My questions are if we teach everyone how to use filters, and someone saves the sheet with the filter turned on (but the filter is not shared), does the next…
-
Building contingency into project plans
What is the best way to manage tasks that have a high degree of uncertainty in the duration? An example might be resolving a design problem – sometimes they are quick, sometimes they take a while. A previous software we used, allowed you to put in a best case and worst-case estimate for each task – effectively adding…
-
Fix PDF print function with Latin Extended letters
After a helpless few months of knocking on Smartsheet support doors, our company finally got the answer, to why our texts randomly change from set conditions in PDF forms (font, font size, font weight), to a different text. As it seems, if the text in a cell has any Latin Extended letters (ą, č, ę, ė, į, š, ų....), it will…
