-
Automatic Project Phase Formula
Hello, I am wanting a formula that returns the current project phase. The phases include Initiation ,Planning, Execution, Testing, Implement, and Closing. I want the formula to return the text value of the phase that has the least % started, NOT including phases at 0% or at 99% and higher. In the example below, I would…
-
Formula Edit to default to blue health when dates are blank
We are currently using this in project plans to establish health. We would like to default items without date values to Blue instead of Red when a project is initially provisioned. This way our portfolio reporting isn't showing a bunch of Red unnecessarily when things are initiated. =IF(OR(Level@row = 0, Level@row = 1),…
-
Average Children and Round Down
Good Day All: Can someone help me Structure this Formula so when I Calculate the Average for all Children it is Rounded Down? Existing Formula Yield 0.00%: =ROUNDDOWN(AVG(CHILDREN())) Thanks
-
Unparseable Formula
I have sheet with a few columns, two of which are: symbol column with the status bar a % complete field I want a formula in the status bar which auto picks (i.e. column formula) based on the % in the second column. so i have this formula in column 1: =IF([% Complete]@row <>" ", if([% Complete]@row=0, "Empty", if(and([%…
-
Quarter formula with some exceptions
Hi Everyone, What I am trying to do is create a formula that looks at two things, the status column to check if the status is not started or draft. If it is either it needs to return a blank. If it is anything else, it needs to check the End Date column and determine what quarter it is and return the appropriate value Q1,…
-
Deposit summary report vs. bank statements
Hi, We're trying to create the following project. I would appreciate getting some input on how to program it correctly. As a healthcare billing company, we post all account receivables to the patient's ledger. At the end of the month, we need to tie out the deposits posted to the bank statements to confirm that every bank…
-
Pulling Approved Data from an Approved Row to a Version
I have talked to Smartsheet Support on this one, but I am under a time crunch, so I was hoping one of you Smartsheet wizards can help me solve the following situation: I have a Tracker sheet that contains requests that go through an review/approval workflow Once approved, there is a 'Latest Approved' column (checkbox) that…
-
Countdown to Launch Days
If today is Jan. 28th and I have a launch date of a project of say Oct. 1st, what formula would I use to countdown the days to Oct. 1 for a dashboard widget? So 246 days, then 245 tomorrow and so on.
-
Row limits in Reports / Grouping
I am pulling data from 2 different sheets that currently span about 5,000 rows with more to come. When I create a report looking to group the information certain ways it seems that the row limit inside the Report itself is 2,500, is that correct? When the data is grouped, I cannot uncollapse the groupings unless it is…
-
I am using the VLOOKUP function, but getting #NOMATCH?
I am using the VLOOKUP function to reference another sheet and pull in data. I have it in another area of my sheet pulling different data from a different sheet and it works fine, but this particular one keeps returning #NOMATCH. The screenshots below show the formula and field to lookup, along with the reference sheet and…