-
COUNTIFS Formula Based on Status and Due Date
I'm looking to create a formula that will count the number of overdue tasks. This is based on the "assigned to", "status" and "due date". My current formula is =COUNTIFS({[Sheet Name]}, <TODAY(), {[Sheet Name]}, ="[Assigned To]"). However, this is pulling tasks that are due in the past, but are completed.
-
How do I list all predecessors (direct and indirect) for a given row?
Does SmartSheet have a way to list out all of the predecessor rows that feed into a given row? For Row 22 in the example below, I would like the formula to return the values 20, 19, 18, 17, & 16. Either that, or I would be looking for a list of all direct and indirect successors to a given row. Either would get me where Iā¦
-
Checkbox Evaluates Differently
I have a checkbox column [H-SD (Added)[ with this formula: =IF([H-Supplier Type]@row = "Individual", IF(COUNTIF({SD-EmailPrimary}, [Email (Primary)]@row ) > 0, 1, 0), IF(COUNTIF({SD-EmailPrimary}, [Organization (Email)]@row ) > 0, 1, 0)) In another column, i want to evaluate if that column is checked or not, so I put thisā¦
-
Ranking when duplicates
I need help with a challenging formula. I have the following situation: Row# Value Score Effort Score Priority Score Rank* 1 50 5 45 4 2 70 10 60 1 3 65 5 60 2 4 60 20 40 5 5 70 25 45 3 If Priority Score = Value score - Effort score then rank by priority score (with greatest priority score = rank 1) if priority score isā¦
-
Help need by IF formula
Hi all, I need support by set up of a formula. The case is: - If column 'Team' = Security AND column 'T-shirt size hours' = L = 2 days THAN column Days_Sec = 2 - If column 'Team' = Development AND column 'T-shirt size hours' = L = 2 days THAN column Days_DEV = 2 - If column 'Team' = Basis AND column 'T-shirt size hours' =ā¦
-
how to calculate capacity based on #days, %allocation and otoo request that is on a separate sheet
Hey Smartsheet Guruās I have 2 sheets ā 1 is capacity and the other is ooto ā Sheet 1 ā capacity has names and emails and %the first 3 columns and subsequent columns has week to week start date(as text), end date as text and number of days excluding holidays In the OOTO file ā it is a simple if someone requests timeoff itā¦
-
Bring data from source sheet in to separate columns in data sheet
I have a source sheet with >250 rows with each row having a unique [Criteria]. We assign [Status] and [Approval] status to each row that changes in a regular basis. Demo of source sheet: Given the number of rows, I would like to improve visibility of the changing status's in new sheet that will bring in the [Criteria] andā¦
-
Flag projects at risk
Hi community experts, I'm trying to flag projects that are at risk. A project should be marked "At Risk" if the Status is not Complete, the Due Date is within the next 7 days, and the % Complete is less than 80%. Otherwise it should show On Track. What formula can do this?
-
Health Indicator Claculation
I Am using the below formular in my Health Indicator but even though my project is on track My overall project indicator is showing Red. What have I done wrong any assistance please :-) =IF(AND([End Date]@row < TODAY(), [% Complete]@row < 1), "Red", IF(AND([Start Date]@row <= TODAY(), [End Date]@row >= TODAY(1), (TODAY(1)ā¦
-
Conditional Formatting in Rows Resulting from Formulas
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" toā¦