Hello, I am using Smartsheet for project planning. I would like to track adherence to plan, specifically counting the average of the Start to Plan and Finish to Plan and represent the number separatel…
Using the PMO template, I keep running into errors where my references are broke or incorrect. For example, on my Portfolio Metrics sheet, my references should be listed like below. Instead I only hav…
Hello I'm currently using Smartsheet for project planning. I want a forecasted percentage complete on progress to date from baseline start to baseline finish. Can anyone help please? Thanks in advance…
Hello everyone! I've checked this page https://www.smartsheet.com/legal/limits-policy it doesn't show the storage limit not the numbe of sheets limt. I need to know this because we have hundreds of pr…
I have two formula questions. 1. I have Parent rows with a rollup formula created that takes the avg of the RYG balls of its childreen and creates a status =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", I…
We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to …
@Paul Newcome @Andrée Starå I am having issues matching a cell value from my project status column. My goal is to reference my most recently updated (max modified cell) data entry and return that valu…
On a Gantt chart, I've added a column % Progress Expected and I have it calculating % progress expected per day for each line item, based on the duration; see formula below. =(TODAY() - Start@row) * (…
This there a way in SmartSheet to get a nice view of specified lines in a project plan to create a nice view? I know we can import into Office Timeline, just wondering (hoping) there is a way to creat…
Hi, I am new to using Smartsheet and was wanted to confirm a few things timelines related: Can Smartsheet create predecessor and successor dependencies (FF, FS, SS, SF) similar to MS Project? Does Sma…