-
Formula Range no longer working
Hello - We have a report that is built to feed a dashboard. It has worked fine for close to a year. Today I logged in to complete our weekly report email, and all of my forumulas are showing the #INVALID REF error. When looking at the formula, the 'range' is still there, but it is no longer actually working, it does not…
-
Count on condition between two dates
I have been racking my brain on how to write this formula - for some reason, it did not count anything What I am trying to do is: Count "Complete" between two dates. The formula goes: =COUNTIFS([Actual Start Date]:[Actual Start Date], ">=12/26/2022", [Actual End Date]:[Actual End Date], "<=05/26/2023", Status:Status,…
-
Displaying Multiple Quarters based on Start and End Date
Hi - I would like to request assistance with developing an equation. The equation needs to display one or many Quarters based on the 'Start' and 'End' date of a task. Many of the equations I have tried display the quarter in which the events starts. However, I would like the equation to support the following: If an event…
-
SUMIF Budget when priority does not equal x
I've tried to review this older post (among others) to see if I could figure out why my formula was not working. But was unable to sort out why. Trying to SUM a budget column if the Priority column does NOT equal "N/O" =SUMIF([Priority]:[Priority] <> "N/O"), [Budget]:[Budget]) =SUMIF([Budget]:[Budget], Priority:Priority <>…
-
IF, AND, OR Functions
So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up. thanks in advance: works:…
-
SUMIF Help
I am trying to write a formula to add up a range of cells but only add up the first and the last of the cells that show a numerical value. So in the 3rd row it would add the 21 in the Monday and the 21 in the Wednesday column , in the 8th row it would add the 18 in the Tuesday column and the 18 in the Wednesday column, in…
-
How to write a formula that checks a box automatically.
Hello, I am having issues creating a formula for my sheet to check a box if all cells have been added. Each team member collects and copies the answers to the "master" sheet. I want a box checked when they have added their responses that can flow into a report. Thanks!
-
How do I fix my Corrective Actions ID number to count only the ancestors created under the status?
As of right now I have this as my formula =IF(COUNT(ANCESTORS(Status@row)) < 1, "", YEAR([Date Generated]@row, 2) - 2000 + "-" + IF(COUNTIF(Status@row, Status@row) < 10, "000" + COUNTIF(Status@row, Status@row), IF(COUNTIF(Status@row, Status@row) < 100, "00" + COUNTIF(Status@row, Status@row), IF(COUNTIF(Status@row,…
-
add 7 days to a date
I need to add 7 days to a date, but not in a date column as i need to have a formula below for weeks increasing. the date needs to be Australian format i.e day/month/year.
-
Parent row in report
Hi i have a sheet with ~2000 rows and ~1200 tasks. each task is assigned to worker. the worker need to see only the culomn that i choose in report and update only one checkbox column. the issue is that i want to display to worker the parent rows... and in report i not assigned the worker in parent row.... ony the specific…