-
#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…
-
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)
-
Updating Dashboard
So I have created a Dashboard with Metrics and Graphs only to learn that as the underlying data in the sheet is updated the widgets do not update they are static. Given the number of dashboards to be built it is not feasible to manually re-point the widgets to the latest data. So I need a workaround. Given that the widgets…
-
Formula Help Please
Trying to get a value for columns with Yes. Not total but countif(or(col 1 "yes, col 2 yes etc. I've tried every variation of this: =IF(OR(COUNTIF([O2 under 5 lpm]1, "yes", ([O2 over 5 lpm]1, "yes"))
-
Multiply
Hey, What is the smartsheet furmula for multiplying so far i tried =Skupaj ure za tekoči mesec1 * Urna postavka1 =[Skupaj ure za tekoči mesec]1*[Urna postavka]1 i am trying to multiply monthly hours and hourly rate..... no problem using excel.......
-
Automating RGYB Balls With Date Ranges
I want the status balls to automatically update based on the due date - but I also want the status to go blue after the "Item Completed" column is checked. Ie. If End Date is in the past, or due within the next week = Red If End Date is Due within the two weeks = Yellow If end Date is Due in three weeks or more = Green If…