-
Milestone Tracking Report - Numerous projects
Hi all I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget The data will be across multiple sheets and I'm trying to find a way to trigger both active, complete and in progress data sets so that I can target the relevant stages inside of…
-
Scrolling with a mouse wheel
This is a minor thing but trying to figure out how to scroll up and down in my sheets using the wheel on my mouse. This works in every other piece of software I use but in a Smartsheet I have to use the slider bar on the side to move up and down through a sheet.
-
Task Dependency Block View
Would be awesome to be able to see projects in a format like that used by Casual.pm. Gantt charts make it very easy to see how tasks lead to deadlines, and to identify critical paths, but they are not great at immediately showing how tasks depend on one another, nor the total number of processes in action at any given…
-
Podio and SmartSheet
Is there a way to push projects from SmartSheets to Podio?
-
RGY Status - Overall Roll up
Hello helpful Smartsheet-ers! I have several rows that are utilizing the RGY buttons for health. I am trying to roll these up to a general status based on the choices in the individual rows. Can anyone help with a single formula that would capture: Green if all elements (rows) are green Yellow if one or more elements are…
-
Lookup text or number in last cell
Hello, I know how to do it on Excel, but cant seem to get it to work on Smartsheet. I have sheet that gets updated by a form filled out by other people. I would like a formula that would get the last piece of information added to particular cells in this sheet (add to bottom row) and display this in an overview cell.…
-
Referencing a Column in Another Sheet
I am having trouble referencing a Column in another sheet through an IF formula I am trying to do. My current formulas is =IF({Sheet 1 Range 1} = 1, {Sheet 2 Range 2}). The first Column I am referencing is a Checkbox Column, and I only want it to return the value in Range 2 unless Range 1 is Checked. Whenever I do this…
-
Form Confirmation Options
Is there a way under the Form Confirmation Options to show a confirmation message AND include a hyperlink to a Smartsheet? I see the box accepts HTML code, but it doesn't format correctly.
-
Dependent tasks should not be forced to follow
Hi all, When 2 tasks are created and task2 is made dependent on task1, task2 is automatically moved so it follows directly the end date of task1, and there is no way I found so as to create a time gap between the 2 tasks. My team often wants to work on yet another task, say task3 and have task3 worked in between task task1…
-
SmartSheet vs AutoTask feedback
Hi SS friends! I was hop to get feedback from the community on advantages or disadvantages of SmartSheet vs AutoTask. My company is utilizing both products now and I'm curious if both are really needed. Thanks!