-
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…
-
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.
-
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…
-
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.
-
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…
-
COUNTIFS, WITHIN DATE RANGE, ISBLANK FOR ADDITIONAL DATE RANGE
I need to write a formula for counting active projects that are past due for a current month based on schedule complete date being in that current month and when actual complete date is blank. Project Status = Active Schedule Complete Date = 7.1.20 - 7.31.20 Actual Complete Date = Blank Here is the data and fields I would…
-
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},…
-
Move Rows Error
Hi, This workflow used to work fine. I moved some sheets into a different workspace and now it won’t work no matter what I do. I have deleted the workflow and recreated and it still is not working. Has anyone seen this error or know how to fix it? Below is an image of the workflow. Attached are the source and target…
-
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
-
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,…