-
Is there a formula that will help me to determine if a task has any dependencies (IE: the opposite o
I work on some pretty complex projects and the templates we use have hundreds of tasks that are linked together using the predecessor column. Each project is slightly different and we usually need to delete certain tasks to refine the template into a new project plan. It can be a pretty big pain to delete some of the tasks…
-
Best practice question
Hello, I'm new to Smartsheet as of this week and am getting the hang of things, so please bear with me: What I have: * Large datacenter project involving nine teams* technology inventory for each team * Risk Register report * Migration scheduling report * Dashboard for project health specific to their team What I want to…
-
Adding Task/Status to Dashboard
Does anyone know how to add the below screenshot to a dashboard? I would like to include task and status and the corresponding gantt chart to my dashboard. I would only like to include the status for projects that are indented 3 times on my chart though.
-
Report On Dashboard Split With Gantt View
Some how one of the reports on my dashboard is being split with what looks to be the gantt view. I'm not sure why my report is populating this way on the dashboard beause I have never used the gantt view in the report. Anyone know how to fix this? I attached a photo to show what I'm talking about.
-
Resource Report View
Wondering if there is a way to create a resource view that is more of a traditional calendar view?
-
Back dating
Hello, I am looking for instructions on how to get smartsheet to backdate. For example, I have a due date for a project and I want it to create auto create internal dates based off that. Essentially the end of the project drives the internal deadlines. I am set up to know how long each step takes in days and I was…
-
Resource Allocation
Greetings, I am new to the aspect of resource allocation. I need to know apart from people can objects (computers, scientific instruments etc) be allocated as resources, as I need to keep a tab on the overuse of certain equipments at my organisation. Next, can only people with licensed accounts be tracked as resources on…
-
Issue is not displayed in Gantt view
Hi! For some reason Smartsheet doesn't show my issues and it's estimated time in Gantt view: (see the ones in the rows 67 and 68) (Image attached below.) Maybe that's because of 2.5h estimate, but even if I change it to 2h or 1h it doen't work. Both tasks have dpendencies but Smartsheet system didnt calculate their Start…
-
Scheduled export of sheets
Hi there. I'd love to see a feature implemented whereby a scheduled export of sheets could be set up. I'm thinking in particular about project plans but this could apply to any sheets. We have a team subscription but we don't need to set weekly backups of entire workspaces, but I would love to be able to set certain sheets…
-
Sorting by Date in Exported Excel File
When I export a sheet (Gantt Chart with timelines) to Excel it doesn't seem to sort (e.g. by date) all the rows when indented Task Names are present. It will only sort the highest level Task Name, but I would like to sort all the rows regardless of the Task Name hierarchy. Is there a solution to do this, or possibly a…
