-
Formulas for highlight the difference
I'm new and it would be great if I had help. I would like to know the formula that must be put in a cell to highlight if there is an equality or not between 2 values (see screenshots). I need to do it to highlight the differences during an inventory and highlight them (with the conditional form like "if this is False…
-
How to extract the data from the another sheet?
I am trying to find out the formula that help me to list out how many trading partners that we are currently working on it. The list should not be duplicated and it will be Renault, Titan X, Volvo. Can someone please help me?
-
Collect function feature add multiple columns
When using the Collect function inside the Index function a user must select a range of only 1 column or the error #INCORRECT ARGUEMENT SET is returned. This also means that the row_index of the Index function must also always be 1 as the Collect function is limited to return a single value (as opposed to an array of…
-
Nested IF troubles
I'm looking to do a NestedIF formula where I set up a predictive "Projected Ship Date" column to use additional columns to the below (old screenshot, but I figured it indicated appropriately enough). Not sure what part I have incorrect- but I am getting an #Incorrect Argument Set error. Formula I'm using: =IF([LNP…
-
Weighted Average - Employee Scorecard
I can't quite get this formula right. I'm attempting to create a scorecard where competencies account for 50% (all competency categories are equal) and goals are 50% (performance is 80% and development is 20%). The column is a drop-down but is not restricted to drop-down options. The formula I'm using is =AVGW([Employee…
-
Count if field is not blank and meets other criteria
I need help with a formula. I am trying to do a count of all of the fields where CP60 is not blank if the Check In is Initial Review of Plan and if the Month is 4 and the Year is 2023. I cannot figure out what formula to use here. Thanks!
-
Can multiple form entries populate one row?
Use case: A team lead submits a form reporting a start time for a delay in work, giving information about the delay and crew members involved. Later, the team lead submits another form reporting the end time of the same delay. Is it possible to have multiple entries populate the same row so the team lead doesn't have to…
-
Can you help me finding my syntax error?
=IF(AND(Statut@row <> "Terminé", ([Date prévue de l'événement@row] <= TODAY(-5), "Rouge")); IF(Statut@row = "Terminé" ,"Vert", "Jaune")) What I want is: If Statut@row is not "Terminé" and the [Date prévue de l'événement@row] is equal or less than 5 days before the event, then "Rouge", If Statut@row is "Terminé", then…
-
Date+days not calculating correctly
Hi all, I need to add 21 days to a date referenced in another cell. Ex: 10/15/23 When I use this formula: =DATE(YEAR([Projected Start Date]@row), MONTH([Projected Start Date]@row), (DAY([Projected Start Date]@row)) + 21) I receive an #INVALID VALUE If I hardcode the date into the formula (=DATE(2023, 10, 15)+21, I return…
-
Multiplying where a field may be blank
Hi! I am multiplying 3 columns + multiplying the next 3 columns to get a sum of the total cost. However, here is an instance where "1455 REP Gallons Used" is blank. I am getting the old Invalid Operation now. Would "if error" fix this and if so, where would it go? =IF(ISBLANK([1455 MU Gallons used]@row), "", IF([1455 MU…
