-
How to auto-populate my companies Fiscal Year week number if its a 52 week year?
My companies FY starts 8/1 and ends 7/30. Currently I am using =ROUND(((Created@row - DATE(2021, 8, 1)) / 7) + 0.49, 0) which works perfectly but it shows 56 weeks instead of a 52 week FY.
-
Does anyone know how to convert this SUMIF Formula and REF a date from another sheet
Hi, Were looking to take this active formula which is currently working and replace the date ranges from another sheet (Cross Sheet Reference) . Does anyone know if this is possible ? Because it is time consuming to replace the date range on each formula, we want to be able to edit the date range from another sheet.…
-
MAX/IF +1 Formula
Hello, I have a sheet for our job lists, we have 3 different types of jobs, i am trying to write a formula that will pick the next highest number in each of the sections My work flow, is chose "type of job" and that will generate 1,3 or 5 in "job classification", i am looking to pre populate the Job# with the next highest…
-
Issues with "OR" for multiple columns
Can someone tell me what's wrong with my formula? I know it has to do with trying to insert an "OR" in there but I've tried multiple ways and can't get it to work. Thank you in advance! =COUNTIFS([X Project Status]:[X Project Status], "Active", OR([Y Project Status]:[Y Project Status], "Active"), [Assigned to]:[Assigned…
-
IF Statement
I'm struggling with an IF statement and I'm hoping I might get some help. I'm trying to calculate the due date using the date the request comes in and the timeframe to respond (# days). However, there is the ability to extend the request up to two times, for various reasons. The first formula below worked great for one…
-
Stumped by a formula!
I cant figure out why this formula isn't working and am hoping someone can help me. I have a discipline column, a current date column and a in service required column. based on the time of year and discipline selected, a certain number of in-service hours is required. I.E. from January 1st to April 1st = 6 (hours) , from…
-
How to create a counter and reset when the value changes
I need a formula in the unique main counter column that will count the number of times a value in ID_Main appears. You can disregard this. I looked and looked and wasn't asking the questions correctly. I then after posting I found this from Paul in 2020. It does exactly what I need. Thank you Paul. ="M" + COUNTIFS([Size…
-
Looking for formula to have auto numbers, that subtasks inherit the main task job number
Hello, I am looking for an auto number formula that will have subtasks created in card view auto inherit the parent's job number for every card created. My workplace has a very old sheet that I believe does this but in grid mode and I am not sure how to re-create the effect. The column is a text/number format instead of…
-
Trying to use SUMIF to add columns a crossed a row
Below is the formula I am using =SUMIF([Committed Or Projected]@row:[Committed Or Projected]@row, "Projected", [Jan-23]@row:[Dec-23]@row) The error message I am getting is #incorrect Argument set. I am basically trying to add a row range if a value is set in another column. Can Sumif only be used on columns,s not Rows?
-
Using Multiple IF(CONTAINS with INDEX(MATCH Getting #NO MATCH error
Hello! I have two formulas that works great when broken in two parts, however when combined I'm getting a #NO MATCH in my cell. Formula 1 (works): =IF(CONTAINS("DONE Delivery of Assets", $[Status (External SS)]@row), (INDEX({Cedar Review 360 Link}, MATCH($[Course Title]@row, {Cedar Course}, 0)))) Formula 2 (works):…