-
Progress Bar Automation between 2 Different Sheets
Hi to all you brilliant Smartsheet Wizards! 🧙♂️🧙♀️ I saw a question on here regarding how to "automate a progress bar" and I thought that is perfect for my tracking: Automate the Progress Bar — Smartsheet Community My problem: I want the progress bar in Sheet A under "milestones". But I want it to source the data from…
-
How can I update Jira comments via Smartsheet (and vice versa)
I use Smartsheet with the Jira Connector (I am on Jira Data Center) for project management. I make frequent updates to the “latest comments” column in Smartsheets to provide commentary on certain Jira cards. The issue with this is that comments about cards are either in Smartsheet, or in Jira, but not both. Here’s an…
-
Can you assign a random value based on a list?
I am trying to automate the task of assigning a person to an assignment. Users can submit a form, which generates a row on my sheet. The row then has to be manually assigned to someone to complete it. There are no values that can be used to really assign it to one given person- these are submission for setting up new…
-
AVE or AVERAGEIF when refrencing another sheet
I have my master sheet set up with a duration column. I've been trying to build a formula on my metrics sheet that will allow me to average the duration column based on who is assigned that purchase order. I've tried two formulas, one using AVE and the other using AVERAGEIF and both return the #UNPARSABLE error. The first…
-
Rendering Milestone on dashboard
Creating dashboards and image widgets. There is a problem with the widget pulling from the source file. An example is a dashboard displaying milestones for a project. Milestones are seen as flat parent relationships The project plan has a typical parent-child structure, but the widget does not render correctly when linked…
-
Can Smartsheets talk to each other?
I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…
-
Need help with an NETWORKDAYS formula to pause the day count when a Status is selected
I need help with a NETWORKDAYS formula that will count TODAY() if Escalation Completed Date is blank and pause day count if the Escalation Progress is "Phase 0: On-Hold" and the column for On-Hold Date has a date recorded (and will still count as TODAY() if blank). Current Formula I am trying after searching in the SS…
-
Bulk allocation change in one way in Resource Management
Hi Team, We have a large number of resources in multiple projects. For us, it's very difficult to change the allocation when the project date has been changed. If you can work on this we can extend the resource allocation date in one way for all the resources in the single project it will help us minimize our effort for…
-
How to cross reference dates on a master sheet and then edit those dates on different worksheet?
Total noob here. I have a master sheet with 4 critical dates in regards to completing a major project (new restaurant opening). The critical dates are subject to change as some parts of the project are subject to be delayed due to construction, permits, etc. I would like to only have to change the dates on the master…
-
Do any other companies utilize Smartsheet for Weekly/Monthly Status Reports?
We are looking to move away from Excel based 'status reports' that are emailed each week to something that is more readily accessible and easier to manage/track. At a high level, each week an employee completes a status report on the projects/tasks they are working on or have completed. Our requirements would include: Have…