-
Index/Match/Max Function Issues
@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 value in the selected cell. My current formula for reference: =INDEX([Project (Schedule) Status]3: [Project (Schedule)…
-
Complex Formula Help Needed
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) * ([ADMIN: % EXPECTED DAILY PROGRESS]@row) * 1.1 The problem I'm trying to solve for is I need it to show 0% progress expected…
-
Project Timeline - PowerPoint like view
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 create this in SmartSheet so that the data is always current.
-
Timeline Variance indicators
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 Smartsheet allow for WBS elements to be created through indent / outdent similar to MS Project? Can Smartsheet allow linking to…
-
Update a cell based on a Workflow
I have an approval workflow set based on a cell value. Is there a way to update that cell value once the approval completed? Cell dropdown example: 1. Under review 2. Sent to team 3. Ready for release 4. Released When the cell changes to sent to team approval triggers and once approved cell changes to ready for release. If…
-
Dashboard Template
I have multiple projects that have their respective project schedule sheets and I created a dashboard of one project. I was wondering if there was a way to make a template of that dashboard so that I could make the same dashboard for all of my individual projects.
-
Help with RYGB Formula for Days past Start Date, Blue = Complete Status from Multi Select
Hello Smartsheets Friends, Using a Smartsheet for keeping track of Activation Status. Here is what I am hoping to achieve. 1-7 Days from Handover Date = Activation Call Status - Green 8-14 Days from Handover Date = Activation Call Status - Yellow 15+ Days from Handover Date = Activation Call Status - Red When customer…
-
Say Hello to PPM Function TotalFloat
Hi Community, We are happy to announce the addition of the TotalFloat function to Smartsheet’s powerful set of Project and Portfolio Management capabilities. The TotalFloat() function calculates the number of working days that a task can be delayed without impacting the Project Finish Date. This new formula function will…
-
Modify criteria for Schedule Health
Hello, I am trying to modify the criteria for the Schedule Health using the Project Management Office Template (https://app.smartsheet.com/b/publish?EQBCT=8c1ace8ce2d14472a986005d454626d8) Currently it calculates the health based off of the actual and target start/end dates, however, I'd like for it to also factor in the %…
-
#CIRCULAR REFERENCE with =SUMIF Formula
For each month, I am trying to sum up data depending on the type of project it is. For example, "If the 'Project Type' is 'Strategic', this is the total hours for the month of February," "If the 'Project Type' is 'Operational', this is the total house for the month of February." These the formulas I tried using:…
