-
Resource Management Schedule View on Smartsheet Dashboard
Resource Management already has a great view on the Schedule tab to see if someone is over allocated but unless you have licenses for every user in Smartsheet only Management can use this tool. I would like to create a view/report per individual that looks the same as in the Resource Management Schedule tab and place it on…
-
Automation Trigger Scheduling for Short Term Processes
The situation: I have a simple checklist for my team. I want to set an automation to send a reminder to the assigned team member weekly after a listed due date if they haven't checked off a task by that due date. Currently, if I want the reminder to send at a time relative to the due date, I have to set the trigger to Run…
-
View Multi-Day Tasks in a Report Grouped by Day
I have built a scheduling tool in Smartsheet for my Team to track standard, ad hoc, training, and PTO. I have setup a report that pulls scheduling data from multiple sheets with tasks grouped by start date. I use this report to see how my Team is scheduled during a given week. Unfortunately, in this report, tasks that…
-
Creating daily work schedule for individual team members (from a master project grid).
Hello, I'm building a system in Smartsheet to manage work requests across all projects in my organization. The basic idea is for Project Managers to submit task orders to a common grid, which are then assigned to various team members. Ultimately, this new system will serve as the primary work scheduling tool. The system is…
-
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:…
