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 a…
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 w…
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 …
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 ta…
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 over…
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-…
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 select…
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 ex…
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 cons…
We use Servicenow for technical incident management. Some incidents evolve into work packages for specific tech teams. These teams use SmartSheet for task management. So migrating an incident in Servi…