-
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,
-
Pulling Status from another Smartsheet
Hi, what is the best method to pull the status update from a different Smartsheet? Our technical team has a Smartsheet of tasks and I'd like those tasks and the status be reflected on the overall project plan. However, I only want them to be required to update one Smartsheet. Recommendations greatly appreciated!
-
How can I include comments in a portfolio view?
I'm hoping to use Sheet Summaries on project plans to roll all project information into a portfolio report, but one thing that I need is a way to have a 'status update'. We use comments and the conversation tab heavily in project plans, so I can pull a 'latest comment' column, but I want to pull comments made for the…
-
How do I clear content of a cell? Sheet from: Template Project Tracking and Rollup
Hi, I am new at Smartsheet. I am using the sheet in the template: Project Tracking and Rollup. When I add a column and with a checkbox or a date for an example, the checkbox is in every cell in that column, but some of my rows are main rows and therefore I want the cell to be empty. How do I remove the checkbox from a…
-
Roll up based on selection from one column and count of answers across mulitple columns
I created a form to get feedback from 6 different business units regarding 48 different applications. The participants select their business unit name from a single select dropdown. They then rank each application as “Not Used By Myself or My Team”, “I'm Not Sure”, “Not Important”, “A Little Important”, “Somewhat…
