-
How to automate the predecessor?
Is there a way to automate the predecessor column? I don't want to manually enter each number.
-
creating formula to add many non-adjacent cells
I need to sum/add many (~120) non adjacent cells. They are all in a single column. When I create a formula and start clicking in the cells to include, I keep being returned to the bottom of the sheet where the formula is calculated. Then I have to scroll back up to the top of the sheet to access the next cell I want to…
-
Resource View: % allocated bar
Hey team. When I look at my resource view, both within the project, as well as in the Resource View area, the colored bar is not over Mon-Fri, but over Tues-Sat. I have already changed my account settings to show that our work days are M-F. Ideas?
-
Sort Open Tab List
I frequently have a large number of tabs opened. The dropdown list is not sorted in any meaningful way. I know I can manually drag and drop things to sort the list but it would be very helpful if there were a way to sort the open tabs by name so I could quickly find an open tab. Alternatively, allowing drag and drop in…
-
Is there a way to select from a project schedule the next upcoming milestone?
Is there a way to select from a project schedule the next upcoming milestone. I have a flag column identifyng milestones and a column that calculates for just milestones the number of days between the task finish date and today's date and therfore the lowest value is the next upcoming milesone. I desire to pull the…
-
for one project today all task lines over 1 line height do not show the same height in the task numb
here is what I see, it only applies to one of my projects and I logged out and logged back in to smartsheet and the problem persists. Causes problems when I want to update values in columns to the right with the input box, for dates for example appears 5 lines above where I am expecting it to
-
Report Template?
Is there a way to save a report as a template? Like, so all the columns & criteria stay, but can just choose a new sheet for it to look at? My team & I all need to print our sheets each week, and our manager wants them to all look the same & be uniform, which I thought the easiest way to handle would be to set up a report…
-
Sheets, or partial sheets displayed in 'Sights' dashboard
I know several of us use cell linking to creat roll-up reports of our data, but these reports cannot be displayed in a 'Sight', becase they live on a sheet, not on a report. Is there a way, or can i recommend a functionality, that allows for a sheet, or part of a sheet to be put into a sight for quick visibility?…
-
Multiple Projects in IT, each may impact the other. Is there a smartsheet for this?
We are a firm working on one project in IT. We understand, after interviewing people in many different departments that other projects will impact our project. How can we manage this using smartsheet? Is there a template available for impact/conflict? Thanks in advance!
-
Recuring events
Hi there, Is there a way to schedule recuring events in the timeline without having to insert new individual tasks? This would be for recuring site meetings etc. Thanks Annina