-
Nested IF/AND Formula
I'm trying to get a formula that performs the following for status. Criteria is: Less than 75% complete=Red Between 71%-100%=Yellow 100% Complete=Green This is what I have built but keep getting the "Incorrect Argument Set" posting. =IF(AND([% Complete]@row < 0.7, "Red", [% Complete]@row < 1, "Yellow", [% Complete]@row =…
-
Formula to generate autonumber if cell is blank and another column contains specific phrase
I am looking for assistance with a formula looks at Coulmn1 to see if it contains one of the drop down choices and the column the formula is in does not include a name then a number will auto-generate. For example: =IF([Please select from the responses below:]@row, CONTAINS("I like rain")@cell, AND([Name: is optional]@row,…
-
Conditional Formula with Symbol (Red, Green, Yellow) Dependent on Column Answers
Hello, keep getting unparseable when use formula to get color coded symbols for responses on 4 other cells. Symbols Wanting to Use Color Dependent on Answer of Other Cells in Row Red=filed, yellow=submitted, green=approved Example of formula: =IF(([EHS Reviewer 1: Approved or Filed]@row=Approved,"green",[EHS Reviewer 1:…
-
Return a Blank in an Index Formula
I'm using an Index formula, =INDEX({T3DP V4 - Project Schedule Range 2}, MATCH([Release Version]@row, {T3DP V4 - Project Schedule Range 1}, 0), "") and want to return a blank response if there is no value in the [Release Version]@row. I keep getting a "#INVALID DATA TYPE" message. Thank you, Kim
-
Metrics in capturing SUM per Monthly
Hi Everyone, We are aiming to create a new metric and visualization that will allow us to automatically calculate the total numbers of FTE per month. Based on the sample data set below, the calculation will go like this: February 2021 -> 110 + 200 + 200 = 510 March 2021 -> 20 = 20 April 2021 -> 120 + 4 + 4 = 128 May…
-
Can anyone fix these countifs and sumif functions.
Hello. I am trying to make a dashboard with 2 charts. one that shows how many projects each project manager is accountable for, as well as whether they are type A, B or C. the other shows the income from each project manager's projects, as well as whether they are type A, B or C. to do this I have made matrixes where I…
-
Automation between Workspaces and Sheets
Hello, I'm looking for a way to move rows from a Workspace sheet to an Archive (existing) sheet in "Sheets" area, once the status of the product/project changes to cancelled. Problem: I want to maintain the hierarchy. Ex: "Teste 1" If Status of Children & Parent = Cancelled then move all rows to Archive sheet (>> I believe…
-
Adjusting Alert Times
I am trying to create an 'Update Required' to my team based on a date but I need the time to go out 15-30 mins before the hour. Is there anyway to adjust the alert to be on the :30 or :45? Thanks,
-
Calculating overtime hours
I have the below columns for standard flat rate, travel, and 3 overtime columns (O/T hrs). I want to calculate the O/T hours, according to which overtime column the hours are in, under Total O/T. Appreciate help with getting the formula right.
-
SUMIFS formula help
I am trying to sum Range 1 if Range 3 and Range 4 meet the criteria in quotes but it keeps coming back unparseable. I'm sure I am typing it incorrectly can someone help? =SUMIFS({2021 FLS Small Project Tracker Range 3}, "Accessories & Beauty", [{2021 FLS Small Project Tracker Range 4}], "Beauty", {2021 FLS Small Project…