-
Show date based on other dates
I'm trying to get one cell to show the actual end date of a TSA. We have the initial date agreed, the early term date and the extension. Only 2 of these cells should ever be populated as it can't be extended and ended early. If the early term date and extension date are blank then I want to show the initial date agreed but…
-
How to use SUMIF to cross reference two sheets
I am working on a sheet, Electrical Inventory Modification, that collects part numbers and quantities based on a form that employees fill out. I have another sheet, Electrical Inventory List, that already has a list of parts and quantities. I want the Electrical Inventory Modification sheet and the Electrical Inventory…
-
Copy and paste files
Can I recreate another folder with the same files with all the links? I created a set of files and populated it so I can test my formulas and generate dashboard. Now that its "fully" tested. I want to use the same set of sheets and dashboard for users with "blank" cells for users to start populating. But I want to keep the…
-
Help with a formula to sum the hours by month by project
Hi all - I need some help building a formula that will show the sum of hours by month (see attached summary sheet - columns Jan 2021 Hours / Feb 2021 Hours) by project. The data that it needs to sum is on the Time Tracking Entry sheet. The unique identifier on both sheets is the "ID". Thanks in advance for any help you can…
-
COUNTIFS Reference Another Sheet, Category Type and Date Range
Ask for help: I have a master sheet with all of the data that I am trying to pull from. In this sheet, I have already achieved the desired outcome in the 'Sheet Summary'. Explanation Summary: Count issues by categories types within Q1 Formula in 'Sheet Summary': =COUNTIFS([Category Type]:[Category Type], "HVAC", [Date…
-
Countif todays date and by someone
I want to count how many times someone completes a form today I was able to count if yesterdays date with: =COUNTIFS({Store}, $Name6, {Created}, TODAY() - 1) but can't find a way to calculate todays entries
-
Checkbox if another field contains text, but don't check if it contains other text
I'm trying to check a box if it contains one of several text strings. But if it contains another subset of text strings, I want the box to NOT be checked. I got it working for the finding text portion, but I can't figure out how to make it remain unchecked if the other text strings are found. Here is the first string that…
-
SUMIFs Contains returning unpareseable
Here is my formula that is not working, any ideas what's wrong? The Audience column has multiple options, but I want to track each individually. =SUMIF(Audience:Audience, CONTAINS("DBM",@cell) [Time Commitment]:[Time Commitment])
-
Combining 2 cell contents and add a space in between (concatonate)
I have combined 2 cells content using + , how do I add space back into the 2 words pulled from the separate cells see below what currently looks like, should be a space between the words! Thanks
-
COUNTIFS function with multiple criteria/specific date range
Hello! I've been having trouble getting this formula correct. Here are the details. I want to count the number of "Agree Strongly" and "Agree Somewhat" in the Survey Results column when the date is the current month in the date column. =COUNTIFS({Survey Results Range 1}, OR(@cell = "Agree Strongly", @cell = "Agree…