-
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…
-
Product Development Inflight Project Dashboard
I feel like I've looked at all of the templates and am still stumped on which one I would use to display a 2023 - 2024 project dashboard. Currently my boss put it in a Excel but not in a way that you can sort. I want to be able to use Smartsheets to input all potential product launches under each of the categories. Below…
-
Linking Green Health Indicator with Not Started Status
Used this ask a question feature for the first time last week and it has been a lifesaver. Here goes another one... How do I update my formula's to show the following. Not sure if I need to update both the health and status, or just the health. Show status as 'in progress' if the start date is greater than today's date…
-
PMO Project Intake Sheet & Project Metadata
Hi, I'm using the PMO template to create the intake sheet and metadata. I see where in step 1B you can edit this column. What are people editing this column to say? Does it has to still be a drop down? What if I don't have an edit, can it just be deleted? I'm thinking I can't based on the note below.
-
Card View - Conditional Formatting
Hi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry over to Card View...any ideas? See attachments Any help much appreciated, Jack
-
Can SmartSheet Count & Return all other values besides "X"
Hello Everyone, I have a metrics sheet that is counting specific text ("Alpha") from a source sheet with the following formula: =COUNTIFS({Supplier}, Description@row, {Status}, "On Order") **This works** Ideally, I would like to count all the non-blank cells that do not have "Alpha" inputted. Can this be accomplished?…
-
Project Schedule Health from PMO Template
I've search the community and I think I'm just getting myself more confused since I'm not good with writing formula's. I downloaded the "project plan" template and I am still confused. I would like to show the following (I hope I'm explaining this right 😩): Blue (complete) = if schedule delta is = 0% AND % complete is 100%…
-
Formula to look at specific column/cell depending on the current month
Hello, I want to create a dashboard widget that will show employee FTEs for the current month. I currently have a sheet (Capacity Plan) that list out the employee's name, and then has the assigned projects with FTE breakdown as child rows underneath. Then I have row that calculates the total for the month. For the widget,…
