-
Critical Path not displaying
Hello I have read various other posts about CP not showing. My last task did have a red border but I have since altered this. There is not CP showing. Any advise will be welcome. Thanks in advance Matt
-
Sumif Problem
I get a 'incorrect augment set' error with formula =SUMIF([Int/Ext]10:[BASE VALUE $]100, "Int", [BASE VALUE $]10:[BASE VALUE $]100) and have checked that the column 'Base Value $' is a text/Number format (having looked at previous comments). Any ideas what else to check
-
Form function for SmartSheet
Hi, I have smartsheet to record each building general meeting info, such as building manager, meeting date, building name. In each meeting, we need to prepare meeting supplies (there are around 30 items, such as pen, projector, binder..). I would like to use smartsheet "Form function". Then link is created and I can send…
-
Scoring
Hello, I am trying to setup a Risk registry where user selects the probability (very high, high, low) and formula in a new column says if High, then score is 0.07. I then want to do the same thing with Impact (user selects impact high, low etc. A new column puts a score based on formula: if high, then 0.05). I then need…
-
PMO Use of Smartsheet
Hi, Has anyone successfully used Smartsheet for a portfolio of projects? In particular, we are being asked to track dependencies between projects and to be able to produce a high level gantt chart across multiple projects. Thanks!
-
Notification problems
I was trying to have a notification sent to the "Responsible Party" assigned to that cell so they would receive an email when the row was assigned to them. It seems straight forward but it is not working for me. (I used another email address I have as the responsible party for testing purposes) what did I do wrong?
-
Add a row to an existing update request
Is it possible to add a row to an existing update request. I have a sheet that allows users to select an update frequency (i.e weekly, monthly & quarterly) for their initiative via the webform they use to load the initiative. What I would like to achieve is to set up an update request for each owner (weekly, monthly and…
-
WOULD LOVE THIS FEATURE
For our use, it would be of great assistance if when you are within a workspace, which is housing, say 50 sheets, you could check all and using the actions button duplicate all sheets. I could then move those sheets to a different folder while keeping the data needed and deleting what isn't. We tried templates but our…
-
Is there a way of putting a Vertical line on the calendar in Gantt View
I have created a project sheet with milestone however I want to have a line on the Gantt view that goes from top to bottom on a particular date any ideas?
-
Formula for a new Sight
I want to find out the min, max and avg days taken to complete a project. We have around 68 management systems. So, how can I put a condition for say ABC system was used in 6 projects (from its column) and find out the min, max and avg of the days taken to complete it. In simple words, I have two columns 1. Management…
