I'd like to show a sheet in the dashboard in both: 1. Grid view 2. Calendar view WHen I publish the link to put on the dashboard, it only one or the other. Please tell me there's a way to publish in multiple formats!
Is there a way that you can plot recurrent tasks in a Gantt chart? E.g., writing a monthly report (1 day work) that is due every last Friday of the month. Thanks
Apologies in advance if this has been answered before - and I imagine it must have been since it seems a very obvious and primary requirement for managing projects in a business. Still, for something this fundamental I just can't understand why I can't see anything in the solutions centre or a search here in the community.…
Hi there, trying to make a production line more efficient and I need to attach a file to each order (each order is a separate row). We run off of multiple sheets, and have reports broken down to each department. For example: Main Sheet: Gantt Production - includes all orders (which are linked to multiple reports) Report:…
I accidentally drug a line to link two tasks, they are not dependent on each other. How do I remove the predecessor line?
I've just begun using SmartSheet and like it a lot, but it seems as though my team and I keep running into the same problem in various contexts when using Gantt view. Specifically: It's hard to find today's date. Every time we open a sheet, we first need to make sure we KNOW today's date, and then we spend a couple of…
I am working on a project that we are trying to DataMesh two individual Gantt schedules into one new worksheet together. I've not DataMeshed too much, but is this possible? I use a formula of "Row # + Site #" as my unique identifier for the config. I set up the config, and the first time I kept on getting errors, so I…
We are working to importa 1800 line project plan into smartsheet and have run into a dabilitating problem with the dates. What looks to be happening is that the “Duration” and “predecessors” fields are completely driving the dates for the tasks. Anything with a predecessor is automatically forcing the start date to be the…
I have a construction schedule with start and finish dates. I want the check boxes for the at risk column to automatically check off if the project is late starting or late finishing. Can anyone help me craft the appropriate formula for this? Is there a good formula for this? I was thinking it would be an if then formula…
Can someone show me how to write a forumla that will look up if a cell in the column "Critical date" is populated enter 1 in column "CD2" on the same row. Essentially what I'm trying to do is run a report that summarises all my critical dates but I can't select that date column in my report. If there is a better way I'm…
