-
"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.
-
I need help with my COUNTIFS formula
I am trying to get a count of rows on a sheet that are not Completed AND are not a Sub-Task. My formula works on a syntax level, but it is not coming back with the right answer. Can someone help me figure out what I'm doing wrong? =COUNTIFS({PMO Support Tasks Range 5}, "<>*Completed*", {PMO Support Tasks Range 1},…
-
Calculate number of days a task is later than forecast end date
Hi, Can somebody help? I need to add a column that calculates how many days late tasks less than 100% complete are compared to today see below example, basically need a formula that calculates the 'working days late' column. Thanks forecast end date % Complete working days late (based on todays date) 3/8/20 99% 2
