-
Merged: Gantt view in reports - parent level view of timing.
This discussion has been merged.
-
Notification options for sheet contributors
I would like to request that Smartsheet add the option to follow specific columns, rows, or proofs. Our team uses the rows to assign projects. It would be extremely helpful to get notified every time a specified row is updated as information is edited or added. It also would be extremely helpful to follow a proof I am…
-
Sum of column values that come from function formula
I have created a formulation of a drop down with prices associated with each selection that population on a different column: =IF([Repairs Needed]@row = "Tuck Point", "125", IF([Repairs Needed]@row = "Tuck Point Panel", "450", IF([Repairs Needed]@row = "Tuck Point Column", "150", IF([Repairs Needed]@row = "Tuck Point Major…
-
Using Countifs with multiple references to other sheets
Been playing with this for a while but can not seem to get this right. Any help would be appreciated =COUNTIFS({Editing List-3-2018 Range 2}, >=(DATE(2018, 7, 1), {Editing List-3-2018 Range 5}, ="Name"), Date:Date, <=(DATE(2018,6,30), [Assigned to: Editor]:[Assigned to: Editor],="Name")
-
Pre-Approved Changes Pulled From Approved Standard Changes
Hello! I'm attempting to create a change management system wherein the pre-approved changes can reference previously submitted (and approved by our CAB) standard changes. Pre-Approved Changes - need it to be a drop-down list of pre-populated requests that are Standard change requests that have been approved to become…
-
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…
