-
Reports: Providing $ totals for only new entries
Hello- I've developed a sheet that tracks new registrations, with info like name, program, registration cost, revenue totals, etc. I want to create a weekly report that includes any new entries added to the sheet since the last report, but also to include the total financial sum of those new entries on the sheet. If I…
-
Another status light formula question
Hello all, I'm having trouble with my status light formula. I have the following columns: Date Due % Complete Status (red/yellow/green/gray) This is my current status formula: =IF(OR(ISBLANK([% Complete]@row), ISBLANK([Date Due]@row)), "Gray", IF(AND([% Complete]@row < 1, TODAY() > [Date Due]@row), "Red", IF(AND([%…
-
End Date is auto-filled, how to stop?
Hi All, I have created a sheet for my team and outside of normal columns, we have an extra "Target End Date" to track if we meet target or not. Please see picture. However, the Actual End Date is auto-filled every time I enter Start Date with the default value of the same day as Start Date. It is very inconvenient, I am…
-
Converting a formula to a "column formula"
I am trying to convert this formula into a column formula. It takes selected cells from a row to populate the overall "Status" column. If tasks are "Not Started", the overall status will be "Not Started". The Same would apply for Cancelled. If all tasks are complete, cancelled or n/a, the overall status would be "n/a". If…
-
Parent/Children formula help.
Hi! I am wondering if someone can help me with a formula? I have a parent row with multiple children row underneath. I have a column with checkboxes to be marked when the task is completed. After all children rows tasks are completed, I want the parent row checkbox to become checked. Is this possible?
-
Lookup To Return Multiple Results — Using JOIN, COLLECT
Hello, I am trying to use JOIN, COLLECT to return multiple results but just can't seem to get it to work. This is what I have: =JOIN(COLLECT([Column111]:[Column111], [Column7]:[Column7], [Column1]@row, "N/A")) [Column111]:[Column111] is the range of the data I want to be returned [Column7]:[Column7] is the range of where…
-
advanced formula help!
Hello! I am trying to create an advanced type formula and am having issues. Simple need: I want to know the platform in each quarter. The platform can be one of 5 choices. So using the summary info tab, I want to create formulas to do this. the basic logic is, If Quarter = QTR 1, count "FM - on24 - Automatic lead…
-
Filling Columns based on a Selection From Dropdown
I am working on a formula and cannot get it to return correctly, I need to be able to select one of two options in a dropdown. I was using a vlookup and kept getting the N/A for all of them even if the condition was met. I think I missed an additional trigger. Regions: ABC and XYZ for the example. Based on which region…
-
Contact List formatting from formula only showing email address
I've got a formula that pulls contacts from another reference sheet into a Contact List column, but it also checks an adjacent column for a value to transpose a would-be contact: =IFERROR(IF(Resource@row = "Eric R.", "erussell@email.com", INDEX(COLLECT({IT Requisition Tasks Resource}, {IT Requisition Tasks Task Name},…
-
Using NOT and OR functions in Sumifs
I am trying to create a sumifs function that sums up all of the expenses in a second sheet if they are not labeled "travel". I attempted it with an all-inclusive OR function and then tried it with the NOT function and neither seem to work. It seems that they need to look at cells specifically within the sheet and can't…