-
Dashboards Updating With Weekly Metrics
Hello, I'm trying to figure out how to have our dashboard update automatically when we work off of weekly periods. In other words, we are adding daily metrics that tally into weekly periods. Those weekly periods are collapsed and saved for historical data. Currently, I have to edit the data in the dashboard widget every…
-
Merged: Give Administrators full vision and access to all sheets
This discussion has been merged.
-
Work Flow and Automation help
I am attempting to set up a workflow sheet between operations, sales, and owner. The idea would be to have master sheet where information is fed to it through multiple sources. Once the master sheet has all of the data needed it would then feed to sales and the owners to give them a snapshot of their work. Is it possible…
-
Looking for a labor capacity tracking solution - SS Resource options won't work
Hello, I've seen a few people asking questions that lead me to believe I am not the only person looking for a labor tracking solution NOT at the day level. To use the resource tools in SS we would need people to estimate their workload on a daily basis with start and end dates. We want people estimating hours per week per…
-
Resource Management Question
Hello, Using the PMO SmartSheet template, I have created a PMO to organize all of our Information Technology projects. It is working well and rolling up to the Portfolio Level. What I am struggling with and need advise on is my IT team has a lot of little projects that they can complete in 1-2 weeks and usually requires…
-
Printing a dashboard
I have a Dashboard/Portal that I'm using to display reports that (at this time) collectively take about 2-3 screens to page through. This components of the dashboard change many times daily, so we want to be able to take a daily snapshot to maintain as a running status (and send it out by email). However, roughly one-third…
-
Reporting Earned Value vs Planned Value for SPI Metrics
Good afternoon everyone, I'm new to the SmartSheet community, but my company and I have been integrating SS into our PM work processes for about 1.5 years. We're a VOSB DOD contractor, and we use SS to create simple project schedules that include start/end dates, duration, dependencies, and % complete. We do not resource…
-
IP Whitelisting to Restrict User Access
Is there an option to submit an IP Whitelist in order to restrict user access to our Corp Smartsheet account? I work with a Bank and almost all applications and data are highly restricted with user access limited to only the bank's systems. I am curious if there are options to limit Smartsheet access via an IP Whitelist to…
-
WEEKNUMBER and WEEKDAY
I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) to see who's "on duty" at that time. That contact's name is pulled into an "Assigned"…
-
Need Formula help!
I need a formula that will do the following: When the Date in WKU column has past place the latest NewPromiseDate from the AllPromiseDates column in the cell.