-
Sumif Formula Question
I have a sheet containing a Time Block column as well as a Type column. Both are dropdown columns one with time in hours (.24, .5, .75, 1, 2 and so on), the other has types of activities (Dev Meeting, General Admin, and so on). I am trying to build a formula that adds the time for each activity by the month. I can't get…
-
INDEX MATCH or JOIN COLLECT formula for multiple criteria's
Hello, I am attempting to take a previous intake from and update the new form will allow for more "automation". On the form the requestor/submitter selects a theater and region/country. Once the intake form is received the data in the sheet populates (based on formulas) the following: division, country, PRM, RPL, or SRM.…
-
Sheet Summary Formula
Hi Team! I'm hoping to get some help on Sheet Summary formulas. As you can see per my screenshot below, we have 2 projects. I'd like to do 2 things on the sheet summary: Be able to filter by project name. Once I filter by project name, I'd like to see see the total amount, the total amount due, and the total paid for that…
-
How to change the year on a date based on a condition
SHORT VERSION: How do I write a formula to pull a date from one column and update JUST the year of that date if a condition is met in a separate column Very Long explanation: I have a data base of contracts that must be evaluated either once a year or every 90 days depending on risk level. The initial evaluation due date…
-
How to cross reference dates on a master sheet and then edit those dates on different worksheet?
Total noob here. I have a master sheet with 4 critical dates in regards to completing a major project (new restaurant opening). The critical dates are subject to change as some parts of the project are subject to be delayed due to construction, permits, etc. I would like to only have to change the dates on the master…
-
Applying a formula when a filter is applied
Hi! I am building a team monthly capacity tracker. Right now, it's all in one sheet and I have filters set up based on the 'Owner' column, so each team member can view and update only their projects and activities. I have a formula summing up team capacity each month at the bottom of the sheet. Is there a way to carry over…
-
Status Change
Good morning community I hope you can help, I just can't seem to get this formula right... I have the following status categories on a color wheel Red - Overdue Yellow - Task Outstanding Blue - Investigation Outstanding Green - Resolved The conditions are as follows: If Scheduled Date column is blank then the Status column…
-
Autogenerate IDs built off of other IDs?
Hello! I'm trying to auto-generate IDs that build off of another ID. The formula I'm currently using is: =[Initial ID]@row + "-R" + COUNTIF([Initial ID]:[Initial ID], [Initial ID]@row) I would ideally have it set to: =[Initial ID]@row + "-R" + COUNTIF([Initial ID]1:[Initial ID]@row, [Initial ID]@row) But that's not allowed…
-
Index/Collect/Lookup not working
I've put together a function that pulls an autonumber value from a cross-reference. The problem is that the formula does not evaluate on all records. In the first snippet below the Row Record field does not return a value for all lookup values in the Base PO field even though I have confirmed that all the lookup values…
-
Health Status Formula
Hi! Currently, I have a formula in place to indicate R,Y,G Health based on the Start/Due Date. Is it possible to add an =OR function so that if "Status" column is switched to complete the Health will indicate green. Sorry .. very new to this.
