-
What is wrong with my formula?
I'm trying to do multiple IF formulas to show a Green, Yellow, or Red traffic light based on a % complete column. I can get "Red" (<70%) to show by itself, "Green" (100%) to show by itself, but I can't get the yellow range or all three together. What is wrong below? =IF([% Complete]3 = 1, "Green"), =IF([% Complete]3 <1 AND…
-
Sumif in a RYG symbol column
Hello, I have a formula that returns a Red, Yellow, or Green icon depending on criteria in another column. Red, Yellow or Green correspond to a priority in our work order flow. Then, in a metrics summary sheet, I have a Sumif formula based on the status (Red, Yellow, or Green). At times, we need to override the formula,…
-
Multiple IF functions Nested
Hello, I would like to Nest two If functions in one cell. Below is what I have, but I am receiving an error #unparseable. =IF([Sales Person 1]2667 = "Y", ([Net Profit]2667 - 100) * 0.5, IF([Commission due]2667 > 0, "0" )), ([Net Profit]2667 - 100) * 0.4) I would greatly appreciate your help. Thank you.
-
Double Notifications
I have a work flow set up for vacation requests at our company. This is what happens: Enter information on a form Form is sent to relevant project Manager for approval If approved it is copied to another sheet to populate a calendar view on our dashboards, if it is denied it kicks an email back to the submitter. I only…
-
"Smartsheet Formula Examples" template cell references issues
The "Smartsheet Formula Examples" template, while very helpful, appears to have a variety of issues with cell references that have been moved over time. Somewhere around row 26 things start to get weird. Is this only on my copy of this sheet? I did delete it from my workspace and reload it to see if it would be fixed, but…
-
IF(OR) trying to OR 3 expressions
From what I can see I should be able to 'OR' 3 expressions, but I keep getting unparseable. =IF(OR(Required@row = "Full Topo including underground services",(Required@row = "Full Topo excluding underground services",(Required@row = "Drainage trace only"), "Yes", "No") Any help appreciated. Regards Paul
-
Can someone help me get my SUMIF formula to work??
I am not as savvy as I want to be with SmartSheet, but I am hoping someone can help me manipulate this data the way I want to. I am trying to to summarize each individuals resource hours spent in meetings within a certain project. I have created a basic sheet that shows all of the meetings, the meeting length, and then who…
-
Trying to create a simple IF..OR..ISBLANK formula
I'm getting an invalid operation error and I know I'm making a simple mistake but I've tried everything... =IF(AND(NOT(ISBLANK([Launch Date/Prod Release/Go Live)]4)), >=TODAY(-7)), 1) IF the Launch Date/Prod Release/Go Live cell is not blank and the date in the cell is greater than or equal to the date 7 days ago, the…
-
Update triggered on completion of a subtask
Hi all, I need some help changing the status of an item to 100% when the first subtask for that Item in another sheet is completed. The working sheet has the following columns and I'm trying to update the "Complete Percentage" column The Target sheet has the following: So when the 1st subtask of "General Arragement…
-
COUNTIFS formula with a percentage but I need it to round up
Hi I am using this formula =COUNTIF({DA Audit Tracker Range 1}, "Y") / 273 * 100 + "" + "%" It is giving me the right % answer which in this case at the moment is 67.76557%. But I just want it to round up to two decimal places ..... how do I do that? Thanks Blayne