-
IF function with an additional modifier
Hello, I have a basic question that I can't seem to find any answer for. Is it possible to use the IF function and have the result modified in the same cell by a value in a different cell? So here is my formula for the display column: =IF([Code 1]@row = "Overtime", "$2.00", IF([Code 1]@row = "Doubletime", "$4.00")) Now,…
-
How do I add up individual quarterly cost?
Hi all, I have this datasheet with all the materials I ship. I have made columns to extract the quarter. Also, if you look at the right each row has a total cost section. I'm trying to get all the shipped items costs to be added that fall under the same qtr. So Qtr1, Qtr2, Qtr3,Qtr4 will have a separate calculation. The…
-
Formula Error
I used a current formula in one sheet to format a new one and cannot figure out the error issue. Its saying #Incorrect argument set =IFERROR(COUNTIF([Medical Necessity]@row:[Collection Plan]@row, "p" / COUNT([Medical Necessity]@row:[Collection Plan]@row), ""))
-
Today function issue
Hello Everyone, I want to address one issue that I am facing for a long time. I am using today's function in my sheet to check today's date for like birthdays or anniversaries and set the automation for 10 AM (Time zone in India (GMT+5:30). For Example - Assume on 23t December it was my birthday so at 10 AM I should…
-
Fonction Date + Counif
Hello everyone, I am looking for a formula allowing me to return the projects in progress during the month. In my logic the formula gives this: IF(AND({2022 Plage 1}@row >=[Colonne5]2; {2022 Plage 1} <= [Colonne5]3); COUNTIF({2022 Plage 2}; [Colonne principale]@row); "") With : [Colonne5]2 =DATE(YEAR(TODAY());…
-
Network Days where same day = 0
I want to know the number of working days between two dates but when the two dates are the same day I would expect it to report 0 but instead its reporting 1. For my purposes items done same day would be a 0. Items completed a day later would be 1 day and so on.
-
Can't add days to a Date
Hi, It seems like I cannot add days to a date by a formula. Formula is below: =[CX Finish Date (F)]@row + 2 And see the Screen shot below, above formula adds the number "2" to the end of the date as a text. However, it is expected to have 2 days added up to the date that was selected. Thank you in advance.
-
How can I record "old answers?
Hello, I was wondering if there was a way to record old/initial updates to a cell. I am trying to record the most recent Z# to the most recent cage cart update. The problem exists when the same cage cart is spotted with a defect. The sheet on the left contains the carts that we have found to have a defect with the…
-
#INVALID VALUE error with collect/index/match/small function
Hi all, Feeling like I've got a real head scratcher here- I have been struggling with this formula creation for the past few days and am hoping that the gurus can help! Within my sheet, I have UniquePart pulling in a list of unique values from a source sheet. The frequency of the part within the source sheet is then…
-
Summary Report
I am trying to create a report that summarizes my Mods per week. I tried putting a Summary in the sheet and then creating a report with this data. Problem I would have to create a summary for each week (52). Then I would like to have the same with the Item totals per week. I did create a column with week totals for Mod and…