-
Build Report for Group of Users
We have a number of User Groups.. some users overlap groups, as many of us wear a few hats. I'd like to build reports that run through the "ZZZ Workgroup" and look for lines that are assigned to anyone in "Group AAA." Perhaps also reports that pertain to "Group BBB" and "Group CCC" Yes, I could select each person in the…
-
Maintain dependencies on drag and drop in GANTT view
Hello, I have a support request on drag and drop dependencies. * SMARTSHEET changes the date, if I drag the predecessor bar to the successor bar * SMARTSHHET looses connection of dependencies if I move a connected bar left or right This "simple" described problems can be fixed manually by myself but it's annoying,…
-
Number and Fraction Format
We currently use a considerable number of sheets that need numbers to read as fractions. (Construction/Exhibit Industry for dimensions) Unfortunately, if you type out a number as a fraction it cannot be used in formula. Excel can translate easily between decimal and fractional display with cell formatting. Will there be a…
-
Future Date Issues
I've noticed that some of the dates entered, if too far in the future will revert to last century. i.e. January 5th, 2050 will work correctly if entered as 01/05/2050 but will think it's January 5th, 1950 if you enter 01/05/50 Also, once you enter the date as 01/05/2050 and it is shortened to 01/05/50, if you edit the date…
-
I deleted my Predecessors column and now have no access to deleting any Predecessors relationships.
The docs say I can do this in the Gantt window, but I've found no specific instructions on how to do that, and haven't been able to intuit this process. Another solution would be to restore my Predecessors column. Inconveniently, copying and pasting columns between separate sheets "is not supported at this time." I imaging…
-
Timer for smartsheet tasks, optimally with comments
Hi, I was wondering if there is a way to easily log time spent on a task and add, optimally, to add comments when finished. Here is what I envision: There is a little clock or stopwatch icon for every task row. I click the icon and a timer starts for that task, maybe turning green to indicate I have started that task. When…
-
At-Risk Flag
Good Day All, I am wondering if there is a way to apply this format to my sheet. I want to be able to move a task to the executive dashboard automatically/ real time. For example, I want to be able to mark a task as at-risk and the task will move to the project dashboard automatically. I am still completely new at…
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Drop Down List Selections
Can I build a drop down list that allows multiple choices to be selected?
-
Selecting Multiple Values from a Dropdown List
Does anyone know if there's a way to enable uses to select multiple values from a dropdown menu? My only other option is creating several columns with checkboxes, one for each option. Any tips are greatly appreciated!