-
Tasks on Track and Off Track Count
Good Afternoon All, The Vice President has decided that for each project plan he wants to know the below information A count of the number of tasks that should be in progress (using start date) A count of the number of tasks that should have started and havn't (using % complete and Start date) A count of the number of…
-
SUMIF Returning $0
I have a "Status" column with dropdown options of "Pending" and "Accepted". I have a second column (CAR Amount) with a dollar amount in each cell. I want to sum the amount of all rows marked "Pending" and then do the same thing with all rows marked "Accepted". I have tried: =SUMIF([Status]1:[Status]64, "Pending", [CAR…
-
Need a How-To: IF [blank addends], blank, IF [values], sum
I'm working with this formula, which gives me [Expected Completion Date]: =[Planned Start Date]1 + [Expected Days Duration]1 Without values in Planned Start or Expected Days, I get #INVALID OPERATION in the Expected Completion. What's the simplest IF/THEN to use that will return a blank in EXPECTED COMPLETION if we haven't…
-
Formulas that work across sheets
With no pivot table functionality & Reports having no aggregating functionality, and Sights having on wigdet capable of aggregating data we struggle to summarise or aggregate our data up. We could create a summary sheets that count/sum our data in other sheets IF Smartsheet allowed formulas across sheets (which it…
-
COUNTIF with WIldcards
I have a survey sheet where all columns start with specifc chars: D-, I-, O-. Each contains differing descriptions following the "-". I want to create a sum of all "D-", "I-", etc. disregarding the descriptive text following the "-". I am using COUNTIF([Column1]:[Column X],="D-*") with no luck. Always returns "0" unless I…
-
Formula to include a specific range and all new entries
Hi, I have a formula as per below and I want it to start calculating from row 6 to the bottom and include all new entries. Can you please help me? =SUMIF([1 - BT]6:[1 - BT]44, "KS", [1 - # of BT]6:[1 - # of BT]44)
-
Return Column Name using a Formula
I have several columns I use to track dates for different steps in a process. i.e. Ordered, Delivered, Installed. Is there a formula that will return the column name of the latest date across these columns. For instance, Ordered = 8/4, Delivered = 8/15, Install = n/a. In my "Status" column I'd like to return "Delivered"…
-
New data from Web Forms lands outside analysis range
We have a number of Smartsheets that gather data using web forms. Once the data has been gathered we analyse the responses received via the smartforms using formulea at the botton of the sheet (COUNTIF) This works really well and once we have this data in we can use the charts available in Smartsheet labs to present the…
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
Computing duration from a min and max column
I'd like to support a Min Duration and Max Duration, and then compute Duration as an average of the those two and be reflected in the Gantt Chart. Is it possible?