-
SUMIFS not working (referencing another sheet)
I'm struggling with getting a SUMIFS function to work properly that is referencing another sheet. So on my sheet with the function, I have it as: =SUMIFS({Total GL Detail Range 4}, {Total GL Detail Range 5}, Project8, {Total GL Detail Range 3}, Title@row) ...where the "Total GL Detail" is the other sheet referenced. Range…
-
Add a flag formula
I'm looking to add a flag for when a item has been open for more than 90 days - for that I have the formula below which works: IF(Submitted@row <= TODAY() - 90, 1, 0) Where I'm running into issues though is if there is no date in the Submitted column, then the flag is turned on. I'm trying to have the flag only show when…
-
Comparing Dates
Hi, I have a Planned Date and Actual Date and Final Date column. I need formula where Final Date column, has Actual Date, but when Actual Date is blank Final Date should have Planned Date. Planned Date | Actual Date | Any help is much appreciated! Thank you!
-
Checking another sheets Tick box and returning a value based of Row ID
Hi Helpful community! Hopefully I've titled this correctly. I have two separate sheets, a master and a task sheet. I've been having trouble creating a formula that checks the "task" sheet and returns a value based of if a tick box is marked. Main Sheet looks like this:- The Formula i need is for the "Promo Materials"…
-
How to Calculate End Date by Adding the Total Months to Start Date
Hi All, I need help on how to automatically calculate the due date by adding the columns "Last Maintained Date" with the "Interval (months)" column. I hope to hear from you soon. Thank you!
-
Formula as alternative to Dynamic dropdown menus?
Hello, I have seen in previous discussions that dynamic dropdown menus are not available without a third party app or Data Shuffle. Neither of those are options right now, so I am trying to do the next best thing. My situation is this: I have two sheets , the first sheet is a a project specific sheet that has the task…
-
Count Parent rows only based on checkboxes.
Hello again! I am trying to create a better sheet. I have what I would call a "template". For each of the check boxes in the Report column, these correspond to a parent row. I would like to be able to have a formula that would count ONLY the parent rows. So, in my screenshot below as an example, the 3 checkboxes I have…
-
Sheet Reference Comparing two Totals to determine Indicator
Hello, I am working on a formula where I am referencing one sheet with numbers to set an indicator on another, to determine if something is Red, yellow or green. I am using a single cell called difference on my reference Sheet. The code should read if Less than 20,000.00 it should be Red, greater than 100,000.00 should be…
-
Formula trouble: Average score for specific word in multi-select column
I have scrubbed the community board for this answer, but was unable to find the formula I needed. Therefore I am sending out an SOS. :) On the master sheet, I am calculating scores and an overall total average. Example formula: =AVERAGEIF([NE: Value]:[NE: Value], <>"") -- This is working On my metrics sheet, I would like…
-
COUNT function for Contact Lists
I am trying to write a formula to Count the number of Rows assigned to specific people. The column I'm referencing is a Contact List and the outcome is providing a value that is incorrect. Is there a different way to write the formula? I'm doing a COUNT, choosing the Contact List column and then using the contact list name…