-
Formula for Smartsheet PMO Template Project Plan Schedule Health
I have set up a Schedule Health Formula in the Project Plan where it calculates the Schedule Health based on the Health of the Children Rows. For Example, if 1 of the 6 Children Rows(Level 2) is Red then the Parent Row(Level 1) is Yellow and if there are 2 or more Children row(Level 2) are Red then the Parent Row(Level 1)…
-
Cross Project Dependencies
Hi SmartSheet Community! I have built a portfolio of projects and I want to create an additional project within the portfolio to capture action items that need to be completed before some of the tasks in the related projects could complete. Example, I'm making ice cream and I have three projects in the portfolio: Vanilla…
-
Edit destination sheet when changes are made to a source sheet
My organization has multiple divisions working on several projects, so each division has their own project management sheet to track project timelines, tasks, budget, etc. I was hoping to have each division's sheet automatically update into a larger organization-wide project management sheet so our executive leadership can…
-
Drop Down List assigning a score
I am trying to figure out the correct formula to execute an output I have created a Drop-Down list that the end user can select one or more options. Each question has an associated score with it (1 or 2). I want the output to generate the overall score and a background color in a separate column. I have it created in excel…
-
COUNT(DISTINCT(COLLECT - Counting a value per employee
Hi, I'm trying to count how many values I have for certain people. I have two values that are assigned to the employees daily, for each day we have a value of either "Y" or "N". I want to count how many "Y" an employee has. I'm getting this information from a big database, to have it summarized in a small one. I've tried a…
-
How to handle large projects
In this article, we show how to handle large projects by splitting the projects into subprojects while keeping coherence and synchronicity by linking cells between sheets as available in Smartsheet. This technique is safe and robust. The tracking of the project's progress remains fully automated. We have thus put the…
-
Direct link to status in automated email
Hi community, Is there a way to include a link in an automated email that allows the receiver to mark a task as complete directly from the email, without having to open the sheet? Thanks! Louisa
-
Hello to all. Will start sharing my experience soon
Hello to all. I am using Smartsheet since many years. So far I didn't share my experience with the community. This is about to change now. I plan to post regularly on these topics: - experience with Smartsheet in large industrial projects - tracking progress of projects - forecasting end dates of projects - using…
-
SUM of Hours column
Hello, I have four columns: Task | Hours | Assigned to | Total hours The 'hours' column is how much time (hours) it will take to do the task, the 'assigned to' you can assign the task for more than one person. Now I need the 'total hours' column to show me how much time it will take for a task (example: Task1 takes 1 hour…
-
Any solutions or workarounds to dropdown/cell-linking issues?
Hi everyone! It's a bit of a wall of text ahead, so apologies in advance and many thanks to anyone who dares read it. I’ve got a bit of a beast of a project I’m working through and I’m hoping y’all would be able to help me work out some of the pain points I’m running into. Some of them could probably be alleviated with…
