-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Formula to calculate # of Projects per Month
So I keep getting #unparseable from my formula below. =COUNTIFS({Creative Marketing Request Tracker Range 5}[Start Date]:[Start Date], <=DATE(2025, 11, 30), [End Date]:[End Date], >=DATE(2025, 11, 1)) I have a lot of projects with different "Requested Delivery Date" (column header). Above I attempted to find how many…
-
Report for past due tasks
I'm creating a report to show past due tasks. I want the report to show tasks that: Are not marked completed and have a finish date in the past Are not marked completed and have a target date in the past I'm having trouble with the target date is updated to a future date, I do not want the task to show on the report if the…
-
If Contains formula
I need to compare a column that contains only week ending dates to a reference sheet that has a date column that could be any date. And also look for the word 'yes' in a range of words. And also look for the word 'weekly' from a reference sheet. All this to give a return of 'Completed' if true, and 'Incomplete' if false. A…
-
Need help with Index formula across sheets
I have a Master sheet that I would like to source information to subsheets for Project columns, of which then the % complete and date complete on each subsheet gets Indexed back to the Master sheet. However, I am needing to add 2 lines on the Master sheet to populate on all of the subsheets, but when I assign them unique…
-
Creating a Gift Card Inventory and Transaction Log
Hello! I am attempting to create a gift card inventory log and a transaction log. I created a master sheet to house the general inventory. I also created a transaction log. My goal is for them to talk to each. The master sheet will house all of the gift card information like, the serial numbers, description/store, value,…
-
Add Values to Each Dropdown Value
Hello, We have a Supplier Dropdown with the name of each of our suppliers. I would like to create a formula that takes each of those values and goes out to another table (Supplier Directory) and returns the City, State, and Country of each of those suppliers. I have the following formulas that look up the city, state,…
-
Created Date by column to show on line entries only
Hi How do i set created Date column to only show entries from line 24 downwards?
-
Formula check: select drop down option based on other columns
Hi everyone, I'm looking to use a formula that will select one of my drop-down statuses (Rejected) IF the Avg Score is below 50% OR one of the other columns has the selection of "Red Flag (quality/ethical/concern: cursing, condescension, etc)." Otherwise, I want the field to populate the other status (Acceptable). I'm…
-
Merge Date and Time, then calculate hrs remaining
Looking for your help, so we have a project manager that has the below information on a sheet. And what he is looking for, is to have a column that calculates how many hrs left each row has before it reaches its planned end date/time. That way they can either add filters or conditional formatting for the rows that are due…
-
Separate predecessors for start and end dates
How can I set the start date based on a predecessor of row X and set the end date based on a predecessor of row Y?