-
Data Shuttle Running 5 Hours Early
Based on the log, all my nightly Data Shuttle workflows ran 5 hours earlier than they should have last night. (This may have been happening for a while and I just didn't have reason to notice.) Example: scheduled for 1900 hours, ran at 1400 hours. That's kind of a problem since the data for the day isn't all taken care of…
-
Can you provide instructions or best video for adding team members available/unavailable time to "Sc
Can you provide instructions or best video for adding team members available/unavailable time to "Schedule" tab/view in Resource Management
-
Formula Functions causing cell references limit error?
Hello, I'm trying to determine which FUNCTIONS I'm using in column formulas of a program schedule sheet that may be causing too many cell references so that I'm going over the limit of 25 million references (when I have around 3000-4000 rows). Most of my formulas just have @row formulas, but I don't know what some of these…
-
Has anyone used Smartsheet for production resource scheduling?
My company is still relatively new to Smartsheet. We have a project template that is working well for us. However, we also would like to also find a way to use Smartsheet to help us plan/schedule our production resources. We want to be able to line up projects, machine hours, and labor (non smartsheet users) so that when a…
-
CONFLICT COLUMN (Shows where issues are when scheduling)
I have started to develop a CONFLICT column, that is, a column to show/ highlight where the same ASSIGNED TO/ RESOURCE/ MACHINE has been allocated on the same day, thus identifying potential conflicts in the schedule. The columns counts the number of instances where the START DATE and ASSIGNED TO are the same and only for…
-
How To Have Risk Column Automatically Update Based On Certain Conditions
Hello, Can anyone help me write a formula based on the following conditions. Risk Status = "Green" if the following conditions are met: [Delivery Confirmed] is checked Risk Status = "Gray" if the following conditions are met: [Release Date] is Blank Risk Status = "Red" if any of the following conditions are met below:…
-
Change start date without breaking dependencies
Hello, how can I change the start date without breaking the Predecessors? I want to keep the predecessors and be able to change the start date. i want the assignee to update the start date and at the same time i want to keep the duration for the tasks locked, and automatically delay the next task (dependent). example: lets…
-
Changing Finish Date based on % Complete Column to Update Schedule for Predecessor Tasks
Currently in a Project Sheet there is no way to automatically change a Date in the Finish column once the % Complete column changes to 100%. I am trying to have the schedule auto update the predecessors start and end date based on the date the ancestor task actually was completed. There is currently no way to automatically…
-
Setting Up Priority Predecessor and Automatic Task Allocation in Smartsheet
I am currently managing a project with approximately 500 tasks, and new tasks are being added every week while others are completed. My tasks are divided into three priority levels and fall into different categories: short-term one-time tasks, medium- or long-term one-time tasks, and recurring tasks (monthly, quarterly, or…
-
Creating Linked Sections of a Schedule
Hi first an introduction to what I am doing. I am a construction manager and I am exploring Smartsheet to up the efficiency. Call it R&D if you will. I wanted to describe what I am looking for without filter , I hope an expert tells me if it is feasible. The function I am looking for is this: I have different parts of the…
