-
CountIF Month AND Year
Trying to perform a CountIF AND function where a cell counts the reference cell containing a Specific Month and Specific Year. The following formula is returning unparsable error: =COUNTIF({EHS Visit Tracker - DoV}, IFERROR(MONTH(@cell), 0) = 1), IFERROR(YEAR(@cell),0)=2020) Can you help?
-
Check box if date is equal to or between dates
I want to create a formula to do the following: If the "Created Date" is equal to OR between the "Week Start" and "Week End" dates, I want to check the "Submitted on Time" box. I tried =IF([Created Date]@row, >=[Week Start]@row, <=[Week End]@row, 1, 0) and am getting an INCORRECTARGUMENT error. I'm sure I'm missing…
-
Is anyone out there having trouble getting new automation workflows to run?
I have a large project management sheet with lots of automation that we have set up for many columns. We currently have 60 automation workflows in the sheet and they are all working fine except for some new ones I added recently. Have I exceeded some kind of limit? I have added about 4 columns to our sheet that need to…
-
IF duplicate AND a condition is met, then Check Box
I need to create a formula that will check a box if there is a duplicate in one column and in the same row a condition is met. The duplicate would patient MRN and the condition in would be "Referred". If the MRN is a duplicate and only if "Referred" is selected for both rows would the checkbox be checked on both rows. If…
-
Balls Changing Colors
Hello, Why is the signal status color column populating a color when I have nothing in the value column? How do I stop this? My current formula is =IF(Value@row >= 90, "Green", IF(Value@row <= 84, "Red", IF(Value@row < 90, "Yellow"))) Thanks!!
-
Problem with nested IF statements
I was successfully able to write a formula to fill in the value of the User 2 Action column with the value of User 1 Action if Prod User 2 is not blank: =IF(AND(NOT(ISBLANK([Prod User 2]@row)), NOT(ISBLANK([User 1 Action]@row))), [User 1 Action]@row), "") I would like to add one more level to this where the above works…
-
Sumif with multiple requirements
Column A: Team Name Column B: Total Units Column C: Type Column D: Units Won Column E: Units Lost What formula would I use to determine multiple things. Example: I only want to count Column D if Column A = Red Team and Column C = Evergreen Thanks
-
Assistance with formula
I would like to enter a formula that works like this: In first column - I have a Strategic Account Executive. Each SAE has a Book of Accounts In second column - I have TONS of Strategic Account Names - this is the Book of Accounts in full. I would like to have a formula that when I select Strategic Account Exec in first…
-
Wrong date pasted when copying "Created date" to "Date" field in Report
Scenario: A sheet used to track customer request fulfillment has both a manually entered "Date" field and an automated "Created date" field. The idea being if needed, you could enter records after the fact and still track the correct date for reporting. The data needs cleaning. I created a report for staff to easily see…
-
Formula working for half of the IF Statements
Hi there, I'm writing a formula to translate a %complete Column into the progress bar. So far I have teh formula outlined as: =IF([% Complete]@row = 0, "Empty", IF(AND([% Complete]@row > 0.01, [% Complete]@row < 0.25), "Quarter", IF(AND([% Complete]@row > 0.26, [% Complete]@row < 0.5), "Half", IF(AND([% Complete]@row >…
