-
Resource Management Report - Utilization View - Group by Project
It would be so helpful to be able to group the Resource Management Analytics (Report)- Utilization View by PROJECT. Project grouping is currently available for the Time & Fees view, but not Utilization. See attached.
-
Adding year to quarterly equation to count
I want to count how many projects in each network have expected completion dates within the quarter per year. For example, in Upstream, I know 3 projects will complete in Q1 2024 but 1 will complete in Q1 2025. The formula I'm using won't account for the year and count correctly for what I know are the actual expected…
-
Seeking advice on template sets.
I am new to Smartsheet and am hoping to get some advice on which template set would be best. My biggest concern is meeting the executive's requests. The executives are looking for a dashboard that shows an overview of the 20-25 projects that we will be running soon. Executives would like the dashboard to include project…
-
How can I write a formula to pull data based on dynamic columns?
Hi all, I'm trying to write a formula that will pull row information based on dynamic Columns. My goal is to understand the difference in hours worked between last week and the week before. I would like to be able to flag if a Person has not updated hours in a week. I have a 'raw data' sheet which has team member names in…
-
Calculate start date based off of end date
Hi All, Can someone help me with a formula? I've searched the community and haven't been able to find an answer. I already have a formula in place to calculate the end date based off of the start date and duration of project. However, if I have an already defined end date I'd like to calculate the start date based off of…
-
Task that lasts the duration of the project
I have a task I want to track that lasts the duration of each project. However, since the start/end dates can't be formulas, I'm wondering if there's another way to set this up in my template?
-
Business proposal
I am currently scrutinizing a received business proposal for the establishment of my online travel agency. My objective is to ensure the success of the business by strategically leveraging robust programming languages, frameworks, and technology stacks that seamlessly integrate. This includes meticulous adherence to laws,…
-
Introduction
Hi All! My name is Amanda and I work at an organization that operates convenience stores & gas stations. I work in the Brand Imaging/Marketing group and am looking to better my skills on Smartsheet as it relates to tracking and managing projects! I would love to connect with others!
-
How to keep changes in chart colors?
I have created dashboards that include charts, for which I have selected specific colors for each category. Data for the charts come from different sheets. However, everytime I add a new row to the source sheet, I have to update manually the range of data in the dashboard. When I try to update the dashboard range, the app…
-
PROJECT MANAGEMENT powerpoint templates
Team, Please let me know if you know of a source for ready-to-go powerpoint templates for some basic Project management documents ( Like Project idea, Scope, Business case, charter etc.) Thanks,