-
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
-
COUNTIFS with 2 arguments
Hello, I want to count all the open tasks with are less than 1 week due, I have tried to =COUNTIF({Range 1}, "Open", {Range 2}, <7)), the reference sheet have Open and Range 2 has Days left, in number. But i am getting error incorrect argument. I am sure am doing something wrong. Thank you.
-
comparing two columns to find blanks
I was using countifs:field1,"isnotblank"@cell, field2,"isblank"@cell...that the jist of the formula. Am I on the right track? The columns are names and I need know when someone has entered a name in the "Last" field but not in the "First" field. Getting an "unparceable" error.
