-
Formula with Update Requests
Hello all, Im using Smartsheet to automatize a lead process with around 30 people involved. We get Leads in an external network, I add them to my Smartsheet Sheet and then the one in a contact column gets an automatized notification with the new lead data. After 5 days I need an update with est. values and so on, so I made…
-
Totals By Date
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
-
Decimal
Good day All: How do I get my formula to display in decimal format? My formula currently display 1 but should display 0.5. [C5]14 = 7600 [C6] 14= 3800 Formula: =IF([C5]14 > 0, ([C6]14 / [C6]14)) Thanks
-
#Unparseable with If statement
I keep getting # Unparseable error with this if statement: =IF(RC@row= “RFI-1”, "*Request For Information*” ,IF(RC@row = “RFI-2”, “**Request For Information, Second Attempt**” ,IF(RC@row = “RFI-3”, “***Request For Information, Final Attempt***” ,IF(RC@row= “IFA-1”, "*Request For Approval*” ,IF(RC@row = “IFA-2”, “**Request…
-
RYG Parent/Child Row Status Correlation
Hello, I'm trying to have a formula in my parent row status (red, yellow, green) where it will answer with a "summary" of all the children status. For example, if all 5 children rows were red then the parent row status would turn red. If 3 children rows were yellow and 2 children rows were red then the parent row status…
-
Checkbox based off of dropdown selection.
I'm trying to create a formula in a checkbox column. This column is called complete. I would like the complete column to automatically check once one of two statuses from a status column is selected. The status column has a number of statuses, but the two I need are "Hold/Cancelled" and "Complete". I created an IF…
-
Formulas
I'm completely stuck on this one and not even sure it is possible. I am trying to compile data from a sheet to be used in a dashboard to show total time to complete "phases" of a project. I need a formula that is able to determine "Active" clients and the "Phase" that they are in, and then the processing time for that…
-
SUMIFS AND & OR
I am trying to sum a single column with the following conditions: Year = 2018 AND Division = North AND Project Status = Client Approvel OR Project Status = Business Case Submitted OR Project Status = Under Development =SUMIFS([Net Project Savings]10:[Net Project Savings]1549, [Year Final Business Case Submitted]10:[Year…
-
Need Help with formula: One of 3 values based on a high and low threshold
Trying to set up a formula (IF?) where the value of a cell is either 0, 3 or 5 determined by the value of a result and if it is below a minimum threshold, in the middle or above a high threshold. For the attached example, the first KPI result is 100% so it receives 5, second result is 4 falls in the middle so receives 3,…
-
Referencing Another Sheet: Count
Good day all: I am counting number Rows in another sheet. However, I do not want to include the Parent or Grand Parent Row in that count, just the children and grandchildren. thoughts on how I would structure this formula? Thanks My formula =COUNTIFS({Mi-Config 7.2 WBS Range 1}, 1)