-
DataMesh & Gantt Charts
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…
-
Forced dates when dependency is enabled
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…
-
=COUNTIF field has any value
Hello, My current incorrect statement is as follows: =COUNTIF(Plant:Plant, "DC", [Assigned To]:[Assigned To], NOT(ISBLANK([Assigned To]:[Assigned To]))) I am attempting to count the number of fields with any value in the "Assigned To" column with the plant column being "DC". I have made numerous failed attempts to find…
-
Activity status column based on due date and % completion
Team, It will be great if someone can help me to Color Code/Highlight the activities in my smartsheet based on target completion date & % Completion column that is manually updated. What I would like to do is: IF target completion date is in the past & % Completion is less than 100% mark it as “PAST DUE” IF target…
-
Reporting on Tasks Past Due by Person
I'm looking to collect ongoing data/statistics on how many tasks reach past due. I would like to collect this by person assigned and across all projects and then by month. Any suggestions on how to tackle this using smartsheet?
-
Sending a Web form weekly basis
Hello, Does anyone know if there is a way to send a web form on a weekly basis? I have attempted to create an auto workflow but am only able to create an update request. The issue with this is it overwrites the content that was in the row as opposed to adding it to a separate line. If anyone has insight into this, please…
-
% Complete
Hello, I have a project implementation worksheet set up with parent rows and sub-tasks below them. When I enter a % complete for the sub-tasks, it doesn't reflect in the parent row unless all the sub-tasks reflect 100% complete. Is there something I have to turn off/on in order for the parent row to show a true % complete?…
-
Import "assigned to" from excel or CSV
I want to import data from CSV or excel where one column is the "Assigned to" contact. Using the user name or email address smartsheet does not recongnise the data imported untill it is manualy selected in the smartsheet cell. This would then be part of a project imported with resource management using teh assigned to…
-
Exporting options in Dynamic View
Currently, there isn't a way to export or print a dynamic view report. How do I create a report that provides my vendors with up to date status on all deliverables, allowing them to also be able to export the information onto an excel spreadsheet. My question is how can I design pull communication within a dynamic view…
-
Formula help: if project type = x then sum revenue?
I'm having a bear of a time with forumlas (as you can see from my posting history). I'd like to add up the MRR by project type automatically. I'm currently calculating this by hand and it is time consuming and error prone. See screen shot. I'd like to count the total MRR for all projects labeled MgdServ as an example. Is…
