-
Creating a flagging process
Hello, I have created a form to be fed into a mastersheet so that persons should submit twice weekly, 3 days apart. Because many persons will be submitting weekly, I would want the system to flag persons who havent submitted twice for the week. Grateful for any assistance to create such logic.
-
Nesting IF & AND statements
Hi, I'm trying to populate a Red, Yellow, Green, Blue column based on two row columns: Status and Due Date. I'm having difficulty trying to set the RYGB column based on both column values. In the below, I'm trying so say that where the Due date is less than today and the Status is In progress make it Yellow. but this keeps…
-
Combining AND with HAS and WEEKNUMBER
Hello Again, My goal is to have a formula that will do the following: If the Lot ID@row is found on the {Lot ID} column on an Archive sheet AND The WEEKNUMBER(Move Date) where the Lot ID on the Archive sheet was found is equal to Week#@row THEN give me a value. If not then 0. =IF(AND(HAS({Lot ID- Archive}, [Lot ID]@row)),…
-
SUMIF - looking forward a few months returning a zero after year end
I have this formula to look forward a few months a but once we get into the next year (2022) the result is 0. I've tried several ways but get the same 0 result. What am I missing. Thanks in advance! =SUMIFS([Man Days]:[Man Days], [Start Date]:[Start Date], AND(IFERROR(MONTH(@cell), 0) = IF(MONTH(TODAY()) = 1, 12,…
-
Automatically adding info
I am trying to automate a monthly report that shows what staff member received work apparel. When someone received work apparel, they have to pay taxes on it. So I created a form for staff to fill out when they received the apparel. It has the Date Dispensed, Name, Description of the apparel and how many they took. With…
-
Bring the data in a cell over to another sheet based off of other conditions in a row
What would be the best way to bring the data in a cell over to another sheet based off of other conditions in a row? Example: =IF(AND({Sheet A Type} = "Project Status", {Sheet A Status} = ""), {Sheet A % Complete}, "0")
-
Formula Help
I am trying to write a formula that looks at a column in worksheet 1 and compares to a column in worksheet 2. If they match, populate another column in worksheet 1 with a different set of data shown in another column in worksheet 2. Help :)
-
I'm trying to create an IF THEN formula showing that IF the check box is clicked for >250k
Hi, hoping someone can assist. [continuation from the above] then YES (Y). This interface is strange today, I wasn't able to add the dollar amount. Blah Thanks in advance.
-
Index Match Formula Help
Newbie struggling with a formula. I have two sheets. In the main sheet the Intake Number is auto populated. In the second sheet, staff will input the Intake Number- the intake numbers may not be in consecutive order on this sheet as a result like they are on the main sheet. They will also provide notes on the case (column…
-
Form condition based on another form
Im trying to find a solution for my prob. Witch is i have a form with a dropdown select with names in for example. I want to check if the selection i do on that field is apporved or not based on a value in another sheet Is there a way to do this atm, workarounds appreciated aswell