Project Management
Discussion List
- Is this in your enhancement plan for Smartsheet? I don't find this feature like how I can create charts and graphs like in MS Excel. Thanks
- I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days wi…
- Getting an Invalid Data Type error with this formula: =COUNTIF(AND(FacilityCount:FacilityCount, "TZ"),NOT(COUNTIF(Status:Status, "Green"))) The second "CountIf" is a symbols column. Looking to make a …
- I'm trying to count the number of late tasks in a project plan. The formula I'm using works as long as a row isn't blank. =IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, ""). If I drag the formula…
- Hello! I am trying to find a way to determine resource allocation in project plans so that they more accurately reflect the availability of my team in the resource view. We have individual project pla…
- Hi there, I have created a document designed to check off whether or not we have received scores back from our partners using a column of check boxes. I need to input a formula that counts the boxes t…
- We have the following request. A department has a sheet to track requests from different people/departments. The sheet has request need, type of request, requester name, due date, and many other field…
- Once my data is in the appropriate cells I want to perform a sort by Due Date. When I do this the formula =SUMIF($Equipment5:$Equipment171, "VUTEK", $Tue5:$Tue171) Changes to =SUMIF($Equipment16:$Equi…
- Hi, Newbie question here. Let's say we have a simple SUM formula: =SUM([Column1]15:[Column4]15) Is there a way to specify the row # using a variable or some kind of reference to a number value in a ce…
- Hello, I'm trying to build a template which would allow vendors to log hours against a project and automatically calculate a cost for each task. This calculation looks at the name of the individual re…